Skip to main content
Glama
LSD MCP Server

LSD MCP Server

by lsd-so

LSD MCP server

Image displaying MCP

Immediately gather an aggregation of high quality info directly from a website just by giving LSD the link via Claude MCP.

You will see Claude connect to the internet and:

  • Write LSD SQL

  • Self-correct LSD SQL

  • Run LSD SQL that's connected to cloud browsers

Demo

Here's a demo of what that looks like in action:

Getting trending repositories using LSD

We treated Claude to psychedelic therapy on LSD and now it can just do things. Here's a longer video on YouTube

Related MCP server: MCP-Python

Contents

Quickstart

Dependencies

To run the MCP server, you'll need both Python and uv installed. To use the MCP server, you'll need to download either the Claude desktop app or another MCP client.

To use LSD, you'll need to sign up and create an API key so your queries are privately associated to only your account. You can do so for free with a Google account.

Giving Claude LSD

  1. Clone this repository onto your computer

$ git clone https://github.com/lsd-so/lsd-mcp.git
$ cd lsd-mcp
  1. Update the values in the .env file with LSD_USER containing the email you have an account on LSD with and LSD_API_KEY containing the API key you obtained from the profile page.

LSD_USER=<your_email_here>
LSD_API_KEY=<api_key_from_your_profile_page>
  1. Give LSD to Claude

$ uv run mcp install app.py

Note: Every time you run mcp install, if you needed to update claude_desktop_config.json the first time, you will need to remember to update the path to uv each time you install the MCP server.

  1. Restart the Claude desktop app and, now, Claude should be able to do trippy things on LSD.

Claude on LSD

If it's the first time in a chat session where you'd like to have Claude use LSD, because we're not popular enough to get caught in Anthropic's crawls, you'll need to first leverage our custom prompt which feeds in our documentation as part of the assistance.

Using custom prompt

See the write_lsd_sql function if you're interested in how it works but it just boils down to a convenient rule we added to our SCAN keyword enabling a developer or LLM to retrieve the documentation for our language in markdown (if you'd like to run it yourself).

SCAN https://lsd.so/docs/database/language

Failed to start MCP server

Using custom prompt

If you encounter error messages when starting Claude desktop along the lines of the following message:

Failed to start MCP server: Could not start MCP server LSD: Error: spawn uv ENOENT

First time running an MCP server

If this is your first time using an MCP server on your computer than, to remedy the error shown above, follow the instructions under the Add the Filesystem MCP Server step to create a claude_desktop_config.json file that Claude desktop can know to refer to.

Missing executable

Additionally, if you've never done anything relating to Postgres on your computer, then you may encounter an error message containing something like the following:

Error: pg_config executable not found.

To fix, simply install postgres to your machine using an available package manager. If you're on a Mac, you can do so using brew.

$ brew install postgres

Incomplete path

Otherwise and maybe in addition to the issue shown above, in the location where claude_desktop_config.json is stored (is ~/Library/Application Support/Claude/claude_desktop_config.json if you're running on a Mac), modify the value of the command key under mcpServers -> LSD to contain the full path to running uv (run which uv in your terminal if you don't already know what it is).

{
  "mcpServers": {
    "LSD": {
-      "command": "uv",
+      "command": "/Users/your_mac_name/.local/bin/uv",
      "args": [
        "run",
        "--with",
        "mcp[cli]",
        "--with",
        "psycopg2-binary",
        "mcp",
        "run",
        "/Users/y/testing-mcp/lsd-mcp/app.py"
      ]
    }
  }
}

Once you've done that, restart Claude desktop and the problem should be resolved. If not, please file an issue.

What is MCP?

MCP, short for model context protocol, provides a communication layer between Claude and computer-accessible interfaces such as the filesystem or web APIs. If a limiting factor of LLMs was its detachment from the "real world" since it's just a text generating model, MCP allows users and developers to bring Claude to life.

What is LSD?

LSD SQL, a DSL for the web, enables developers to connect the internet to your applications as though it were a postgres compatible database. Rather than present a new semantic web ontology or make a new internet, it provides a dynamic declarative language that sits atop the existing one.

Designed to target browsers instead of an architecture, LSD allows for powerful parallelization while preserving simplicity with just-in-time tables meaning you can just get data without running a CREATE TABLE beforehand. Sign up for free with a Google account to start querying the internet!

Here's an example of something you can do with LSD, takes ~30 sec if first run

Contact

Reach out to pranav at lsd dot so if you have any questions.

Smithery

Installing via Smithery

To install LSD MCP Server for Claude Desktop automatically via Smithery:

npx -y @smithery/cli install @lsd-so/lsd-mcp --client claude

Available Tools

4 tools
run_lsdC

Runs LSD SQL using user credentials in .env

Inputs: lsd_sql_code (required).

search_tripsC

Returns a list of objects with LSD trips available to the user and what each of them do.

Inputs: query (required).

use_tripC

Invokes a trip on LSD based on its identifier using the [ACCORDING TO] keywords.

Inputs: trip_identifier (required).

view_lsdC

"Returns a URL to a page where the user can view results as well as a visual playback of LSD SQL evaluation

Inputs: lsd_sql_code (required).

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    B3/5.0

    Scored across 4 tools

    Disambiguation4/5

    The tools have mostly distinct purposes: run_lsd executes SQL queries, search_trips lists available trips, use_trip invokes a specific trip, and view_lsd provides a URL for viewing results. However, run_lsd and use_trip could be slightly ambiguous since both involve executing LSD operations, but their descriptions clarify that run_lsd is for SQL queries while use_trip is for invoking trips, preventing major confusion.

    Naming Consistency4/5

    The tool names follow a consistent verb_noun pattern (e.g., run_lsd, search_trips, use_trip, view_lsd), all using snake_case with clear action verbs. There are no deviations in style, making them predictable and readable, though the pattern is simple and not highly structured.

    Tool Count5/5

    With 4 tools, the count is well-scoped for the LSD MCP server's purpose of interacting with LSD trips and SQL. Each tool serves a distinct function (executing, searching, invoking, and viewing), and there are no redundant or missing tools that would make the set feel too thin or bloated.

    Completeness3/5

    The tool set covers core operations for LSD interactions: executing SQL (run_lsd), discovering trips (search_trips), using trips (use_trip), and viewing results (view_lsd). However, there are notable gaps such as no update or delete operations for trips, and no tools for managing user credentials or handling errors, which could limit agent workflows in more complex scenarios.

    Related MCP Connectors

    Related MCP Servers

    • F
      license
      Not graded
      quality
      D
      maintenance
      A server that enables interaction with PostgreSQL, MySQL, MariaDB, or SQLite databases through Claude Desktop using natural language queries.
      1
      -
    • A
      license
      B
      quality
      D
      maintenance
      A server that integrates with Claude Desktop to enable real-time web research capabilities, allowing users to search Google, extract webpage content, and capture screenshots directly from conversations.
      3
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      A server that enables AI assistants like Claude to safely run Python code and access websites, processing data for better AI understanding while providing helpful error messages.
      3
      GPL 3.0