lsd

The LSD MCP server exposes LSD SQL capabilities via Claude through MCP. Once connected, Claude can issue LSD SQL queries to browse and aggregate information from the web using a Postgres-like interface. The server uses the LSD API under the hood to fetch data from websites, enabling Claude to perform actions such as streaming results, applying filters, and composing queries that leverage LSD's web-targeted DSL. Typical usage involves sending a query that leverages the LSD language constructs to retrieve data from web sources and then processing the results within your chat session. The included environment keys ensure your LSD account is authenticated so queries are associated with your profile and usage remains private.

To use it in a chat, initialize the MCP connection with Claude and select the LSD MCP server. Then you can request operations like: running an LSD SQL statement that fetches current trending repositories, retrieving data from a specific website, or chaining multiple LSD SQL steps for complex data gathering. You can also rely on LSD's self-correcting capabilities and streaming behavior to iterate on results as Claude refines the query in real time.

Prerequisites:

• Python installed on your system
• uv (the Micro Client Protocol runner) available in your environment
• An LSD account with an API key

1. Clone the repository and navigate into it:

git clone https://github.com/lsd-so/lsd-mcp.git
cd lsd-mcp

2. Create and configure environment variables in .env (or set them in your shell):

LSD_USER=<your_email_here>
LSD_API_KEY=<api_key_from_your_profile_page>

3. Ensure dependencies are installed (uv is required for running the MCP server):

# If using a Python environment manager, ensure uv is installed (see uv docs).
# Typically uv is installed via your Python packaging workflow.

4. Start the MCP server using uv with the included app script:

uv run mcp install app.py

Note: If you encounter path-related issues, ensure the full path to uv and app.py is correct in your claude_desktop_config.json as described in the project docs. If you update the repository or dependencies, re-run the install step and adjust paths accordingly.

Tips and common issues:

• Ensure your LSD_USER and LSD_API_KEY are kept private and correctly set in the environment variables used by the MCP server.
• If the MCP server fails to start with ENOENT errors, verify that uv is correctly installed and that the command path in claude_desktop_config.json points to the actual uv executable.
• The LSD integration relies on a functioning PostgreSQL environment for certain LSD SQL features; ensure PostgreSQL or equivalent dependencies are installed if you encounter pg_config or psycopg2-related messages.
• When changing the path to the running uv or the app.py location, update the claude_desktop_config.json accordingly and restart Claude Desktop.
• Consult the LSD documentation for specific LSD SQL syntax and example queries to maximize the usefulness of the MCP server.