LSD SQL
About
Enables querqying and analyzing web content using LSD SQL, a DSL for extracting structured data from websites in real-time.
Details
- Author
- lsd-so
- Repository
- lsd-so/lsd-mcp
- GitHub stars
- 63
- Categories
- Database, AI, Design, Search, Frontend, API, Cloud Service
- Tags
- #integration
Jump to
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
LSD SQLCommand (node, npx, python, etc.)/Users/your_mac_name/.local/bin/uvArguments-
Argument 1
run -
Argument 2
--with -
Argument 3
mcp[cli] -
Argument 4
--with -
Argument 5
psycopg2-binary -
Argument 6
mcp -
Argument 7
run -
Argument 8
/Users/y/testing-mcp/lsd-mcp/app.py
Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
-
Argument 1
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
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.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"lsd sql": {
"cwd": "optional",
"env": {},
"args": [
"run",
"--with",
"mcp[cli]",
"--with",
"psycopg2-binary",
"mcp",
"run",
"/Users/y/testing-mcp/lsd-mcp/app.py"
],
"shell": false,
"command": "/Users/your_mac_name/.local/bin/uv"
}
}
}Linux
{
"cwd": "optional",
"env": [],
"args": [
"run",
"--with",
"mcp[cli]",
"--with",
"psycopg2-binary",
"mcp",
"run",
"/Users/y/testing-mcp/lsd-mcp/app.py"
],
"shell": false,
"command": "/Users/your_mac_name/.local/bin/uv"
}Macos
{
"cwd": "optional",
"env": [],
"args": [
"run",
"--with",
"mcp[cli]",
"--with",
"psycopg2-binary",
"mcp",
"run",
"/Users/y/testing-mcp/lsd-mcp/app.py"
],
"shell": false,
"command": "/Users/your_mac_name/.local/bin/uv"
}Windows
{
"cwd": "optional",
"env": [],
"args": [
"run",
"--with",
"mcp[cli]",
"--with",
"psycopg2-binary",
"mcp",
"run",
"/Users/y/testing-mcp/lsd-mcp/app.py"
],
"shell": false,
"command": "/Users/your_mac_name/.local/bin/uv"
}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
Here's a demo of what that looks like in action:
We treated Claude to psychedelic therapy on LSD and now it can just do things.Here's a longer video on YouTube
- Dependencies
- Giving Claude LSD
- Claude on LSD
- Failed to start MCP server
- First time running an MCP server
- Missing executable
- Incomplete path
To run the MCP server, you'll need bothPythonanduvinstalled. To use the MCP server, you'll need to download either theClaude desktop apporanother MCP client.
To use LSD, you'll need to sign up andcreate an API keyso your queries are privately associated to only your account. You can do sofor free with a Google account.
- Clone this repository onto your computer
$ git clone https://github.com/lsd-so/lsd-mcp.git $ cd lsd-mcp
- Update the values in the.envfile withLSD_USERcontaining the email you have an account on LSD with andLSD_API_KEYcontaining the API key you obtained from the profile page.
LSD_USER=<your_email_here> LSD_API_KEY=<api_key_from_your_profile_page>
Note:Every time you runmcp install, if you needed to updateclaude_desktop_config.jsonthe first time, you will need to remember to update the path touveach time you install the MCP server.
- Restart the Claude desktop app and, now, Claude should be able to do trippy things 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.
See thewrite_lsd_sqlfunctionif you're interested in how it works but it just boils down to aconvenient rule we added to our SCAN keywordenabling 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
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
If this is your first time using an MCP server on your computer than, to remedy the error shown above, follow the instructionsunder theAdd the Filesystem MCP Serverstepto create aclaude_desktop_config.jsonfile that Claude desktop can know to refer to.
Additionally, if you've never done anything relating toPostgreson your computer, then you may encounter an error message containing something like the following:
To fix, simply installpostgresto your machine using an available package manager. If you're on a Mac, you can do sousing brew.
Otherwise and maybe in addition to the issue shown above, in the locationwhereclaude_desktop_config.jsonis stored(is~/Library/Application Support/Claude/claude_desktop_config.jsonif you're running on a Mac), modify the value of thecommandkey undermcpServers -> LSDto contain the full path to runninguv(runwhich uvin 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, pleasefile an issue.
MCP, short formodel context protocol, provides a communication layer betweenClaudeand computer-accessible interfaces such asthe filesystemorweb 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.
LSD SQL, aDSLfor the web, enables developers to connect the internet to your applications as though it were apostgres compatible database. Rather than presenta new semantic web ontologyormake a new internet, it provides a dynamic declarative language that sits atop the existing one.
Designed to target browsers instead ofan architecture, LSD allows forpowerful parallelizationwhile 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 accountto start querying the internet!
Here's an example of something you can do with LSD, takes ~30 sec if first run
Reach out to pranav at lsd dot so if you have any questions.
To install LSD MCP Server for Claude Desktop automatically viaSmithery:
npx -y @smithery/cli install @lsd-so/lsd-mcp --client claude
Official Airtable MCP server and skills for working with bases, records, workflows, and business operations from AI agents.
MCP Server For Apache Doris, an MPP-based real-time data warehouse.
Official MCP Server from Atlan which enables you to bring the power of metadata to your AI tools
Query Onchain data, like ERC20 tokens, transaction history, smart contract state.
Read and write access to your Baserow tables.
Introspect and query your apps deployed to Convex.
Interact with the data stored in Couchbase clusters using natural language.
Maritime intelligence for tracking vessels, analysing ports, and exploring ship data.
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
