Browse
→ Data & Storage
→ datasette-mcp
datasette-mcp
MCP server by Simon Willison that exposes Datasette databases to AI assistants through read-only SQL queries. Built for the stateless MCP 2026-07-28 specification. Provides three tools: list_databases to enumerate available databases, get_database_schema to inspect table structures, and execute_sql to run read-only SQL queries against any connected Datasette instance. Installable via uvx or pip. Open source. Released July 31, 2026.
MCP unverified
Integration
| Transport | http |
| Auth | none |
| Endpoint | https://datasette.simonwillison.net/-/mcp |
| Install | uvx datasette-mcp |
Use Cases
| 01 | Query Datasette databases through AI assistants using natural language that gets translated to read-only SQL against any connected Datasette instance via MCP |
| 02 | Enable data analysts to explore database schemas and run ad hoc queries from Claude, ChatGPT or other MCP clients connected to a datasette-mcp endpoint without switching to a separate database tool |
| 03 | Build AI-powered data exploration workflows where agents list databases, inspect schemas and execute SQL queries through datasette-mcp with read-only access controls |
Tags
database sql datasette data-exploration open-source python stateless-mcp
Machine-readable: /api/servers.json
· JSON-LD schema embedded in <head>