Skip to content
MCP server

stoolap

MCP server letting AI assistants query and manage a Stoolap embedded SQL database

Runs locally
Install

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/mcp

Add to claude_desktop_config.json

{
  "mcpServers": {
    "mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@stoolap/mcp"
      ]
    }
  }
}
Install in CursorOpens Cursor, which asks you to confirm. Or add it by hand:

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@stoolap/mcp"
      ]
    }
  }
}
Install in VS CodeOpens VS Code, which asks you to confirm. Or add it by hand:

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.

How AIPoweredBot checks servers