LABSCO SUMMARY
A query language for pages, not a scraper.
The interesting move is that the docs are fetchable by the model itself, so the assistant does not need to already know LSD SQL — it reads the language reference, then writes against it.
What it is
An MCP server for LSD, a SQL-like language that treats the web as a Postgres-compatible database. Give it a URL and the assistant writes LSD SQL, self-corrects it, and runs it against LSD's cloud browsers.
What you get
- Structured results out of a page without you writing a scraper for it
- The assistant writing LSD SQL, watching it fail, and correcting it before running again
- Queries executed against cloud browsers rather than on your machine
- The language's own documentation reachable from inside a session —
SCAN https://lsd.so/docs/database/languagereturns it as markdown, which is how the model learns the syntax mid-conversation - Just-in-time tables, so a query returns data without a schema being declared first
Requirements
Python and uv installed, plus an LSD account and an API key from your profile page — free to create with a Google account. Put LSD_USER and LSD_API_KEY in .env, then run uv run mcp install app.py and restart your client. If Postgres has never been on the machine you may hit Error: pg_config executable not found. — install postgres and rerun.
Setup effort
Build from source — git clone https://github.com/lsd-so/lsd-mcp.git
USE CASES
01
Pulling a list off a page as rows
Give the link and describe the columns you want; the query is written and run for you.
02
Getting through a form to reach the data behind it
The language covers clicking, choosing from dropdowns and entering values, so a result that only appears after interaction is still reachable.
03
Teaching the model the syntax in the first message
Run the documentation scan at the start of a session and the reference is in context before any query is attempted.
04
Collecting the same data from many pages
The language is built for parallel execution across pages rather than one fetch at a time.
BEFORE YOU INSTALL
What to know first
Requires
- LSD_API_KEY in your environment
- LSD_USER in your environment
Where it runs
The documented client runs the server on your machine.
INSTALLATION
Connect your client
Server setup
TERMINAL
git clone https://github.com/lsd-so/lsd-mcp.git
cd lsd-mcp
uv run mcp install app.pyMCP Clients
Claude Desktop
CLAUDE DESKTOP · JSON
{
"mcpServers": {
"LSD": {
"command": "/Users/<YOUR_USERNAME>/.local/bin/uv",
"args": [
"run",
"--with",
"mcp[cli]",
"--with",
"psycopg2-binary",
"mcp",
"run",
""
]
}
}
}The configuration on this page does not set LSD_API_KEY and LSD_USER; the project's instructions put them in a .env file. Check which folder the server reads that file from before you rely on it.