stoolap
MCP server letting AI assistants query and manage a Stoolap embedded SQL database
stoolap is an open-source MCP server for databases. It runs locally on your machine and is started by your AI client.
- Pricing
- Open source
- Platforms
- CLI, API, Linux
- Runs
- Locally
- Version
- 0.5.0
- Listing updated
Similar MCP servers
Install
Run in a terminal
claude mcp add mcp -- npx -y @stoolap/mcpAdd to claude_desktop_config.json
{
"mcpServers": {
"mcp": {
"command": "npx",
"args": [
"-y",
"@stoolap/mcp"
]
}
}
}Add to ~/.cursor/mcp.json
{
"mcpServers": {
"mcp": {
"command": "npx",
"args": [
"-y",
"@stoolap/mcp"
]
}
}
}Add to .vscode/mcp.json
{
"servers": {
"mcp": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@stoolap/mcp"
]
}
}
}Add to ~/.codeium/windsurf/mcp_config.json
{
"mcpServers": {
"mcp": {
"command": "npx",
"args": [
"-y",
"@stoolap/mcp"
]
}
}
}Add to your client's MCP settings (most use this shape)
{
"mcpServers": {
"mcp": {
"command": "npx",
"args": [
"-y",
"@stoolap/mcp"
]
}
}
}Using several servers? Build one config file with the MCP config generator.
About stoolap
The README says this server connects AI assistants to a Stoolap database, an embedded SQL engine written in Rust. An assistant can inspect the schema, run reads and writes, open transactions, read query plans and check the health of a database file, all through standard MCP clients over stdio.
The server is distributed through npm and Docker and runs against a local file or an in-memory database. Operators can add a read-only flag, a row cap and a query timeout so that an assistant cannot return huge results or run statements indefinitely. Writes are refused when a second statement is included, and transaction control goes through dedicated tools so the server always knows whether a transaction is open.
It suits developers who want an assistant to explore or change a local Stoolap database, such as testing queries or inspecting plans, while keeping guardrails on file access. The README notes that COPY FROM reads files with the server's permissions, so it should be run read-only where that is a concern.
Tools this server provides (14)
Taken from the project documentation; the running server may differ.
- query
- Runs one read-only statement such as SELECT, SHOW, DESCRIBE or EXPLAIN.
- execute
- Runs one statement that writes data, schema or settings, returning affected rows or RETURNING rows.
- execute_batch
- Runs one INSERT, UPDATE or DELETE once per parameter set, all or nothing.
- explain
- Prints the plan of a statement, optionally running it with ANALYZE for actual timings.
- begin_transaction
- Opens a transaction at read committed or snapshot isolation.
- commit_transaction
- Commits the open transaction.
- rollback_transaction
- Rolls back the open transaction.
- savepoint
- Creates, rolls back to or releases a named savepoint.
- list_tables
- Returns the names of all tables and views.
- get_schema
- Returns CREATE TABLE and CREATE VIEW statements with indexes and foreign keys.
- pragma
- Reads or changes an engine setting, reads a report, or runs a maintenance action.
- verify
- Checks block checksums of a file database and reports the status of each segment.
- list_functions
- Lists built-in SQL functions with signatures and semantics.
- version
- Reports engine and server versions and the active limits and transaction state.
What it does
- Schema inspection
- Lists tables and views and returns CREATE statements with constraints, foreign keys and indexes.
- SQL reads and writes
- Separate query and execute tools route read-only statements and write statements.
- Transaction tools
- Begin, commit, roll back and manage savepoints, with read committed or snapshot isolation.
- Query plans
- Explains statements and can run ANALYZE to show actual timings and row counts.
- Read-only mode
- A flag refuses any statement that writes data, schema or engine settings.
- Result and time limits
- Caps rows per call and cancels statements that exceed a configurable timeout.
- Vector search support
- Vector values are passed as arrays of numbers within query results.
Good for
- Letting an assistant explore the schema of a local Stoolap database
- Drafting and testing SQL queries against a database file
- Inspecting query plans to find slow statements
- Loading or updating data inside a transaction with rollback on failure
- Checking the integrity of a Stoolap database file
Pricing
Open source
Open source under Apache-2.0
stoolap FAQ
Which MCP clients does stoolap work with?
The README says it works with any MCP client that speaks stdio, naming Claude Desktop, Claude Code, Cursor, Windsurf and Cline.
Can the assistant modify data?
By default yes. Adding the --read-only flag refuses every statement that writes data, schema or engine settings, while reads still work.
What are the requirements?
Node.js 20 or later. The @stoolap/node 0.5 dependency installs automatically with prebuilt libraries for Linux, macOS and Windows, and needs a C compiler for its small addon.
Is stoolap a database on its own?
No. It is an MCP server that wraps the Stoolap embedded SQL engine, which is a separate project.
Is stoolap free?
Yes. stoolap is open source, so you can use and self-host it for free.
How do I add stoolap to Claude Code?
Run this command in your terminal: claude mcp add mcp -- npx -y @stoolap/mcp
What are the best alternatives to stoolap?
The closest alternatives to stoolap are Mysql, Mongodb MCP Server, mssqlcl — SQL Server MCP Server & CLI, SynapCores and MCP Hydrolix.
Where this comes from
- Description: written from the project's README and its MCP Registry entry.
- Install steps: from the official MCP Registry entry.