Prototype · Preview: every server in the official registry, synced every 30 minutes. Sign in with Google to write reviews.Prototype · updated every 30 min
PopNx MCPMCP servers for people who use AI · explained in plain words Sign in

Stoolap MCP

✓ Brand-named GitHub · github.com/stoolap

by stoolapversion 0.5.0i★ 1iRuns on your computerRepository ↗
Registry nameio.github.stoolap/mcp

How to install

What it does

Query, manage and search a Stoolap embedded SQL database (Rust): SQL, transactions, vector search.

  • Connects Runs on your computer
  • Account or key No key needed
  • Category Search & AI memory

Use together with

Skills that teach the AI this kind of work; they work alongside this one

timesfm

TimesFM (Time Series Foundation Model) is a pretrained time-series foundation model developed by Google Research for time-series forecasting.

by google-research★ 35,6421 skills

Skill · How-to guide

Shadowbroker

Open-source intelligence for the global theater. Track everything from the corporate/private jets of the wealthy, and spy satellites, to seismic events in one unified interface. Hook an AI agent up to have it parse through data and find previously unseen correlations. The knowledge is available to…

by BigBodyCobain★ 11,6081 skills

Skill · How-to guide

google-maps-scraper

scrape data from Google Maps. Extracts data such as the name, address, phone number, website URL, rating, reviews number, latitude and longitude, reviews,email and more for each place

by gosom★ 8,2561 skills

Skill · How-to guide

Why it ranks here

Lists are ordered by a usage score (out of 100) built from these parts

Popularity4/80GitHub stars or weekly downloads: the larger counts 60, the smaller 20
Freshness12/12Full marks for a release or code change within 30 days
Still answering0/8The cloud endpoint answered at the last check
Usage score16/100

Quality: Passed 3/3 basic checks (shown, not used for ordering) · Momentum: No data yet (Used only on the Trending tab)

Install

Pick the AI app you use, then copy the settings.

Let your AI install it with one sentence

Please install Stoolap MCP. Follow https://mcp.popnx.com/i/stoolap-mcp.md, show me the commands and wait for my OK before running them.

Paste it into an AI that can work on your computer (such as Claude Code or Cursor). It reads our steps, shows you the commands and waits for your OK. No key, no sign-up. · See the full text your AI reads

Passed 3/3 checks · Runs on your computer · ✓ Commands checked Nov 18, 2026

First: which AI do you use?

Pick your app and the steps appear below.

Works with Claude, with some setup first

Install Node.js on your computer first (one time) · Only the Claude desktop app (Windows or Mac), not the web or phone

Let AI install it

Copy this message into a Claude chat. The AI checks your computer, tells you which file it will change, and waits for your OK every time.

Please install the MCP server Stoolap MCP for Claude on this computer, in this order: 1) Check Node.js with node -v. If it is missing, tell me to install it from https://nodejs.org/en/download; do not install it yourself. 2) Use only this config (already checked by PopNx MCP): { "mcpServers": { "stoolap": { "command": "npx", "args": [ "-y", "@stoolap/mcp" ] } } } 3) Tell me the full path of the file you will change, or the command you will run, and wait for my OK. 4) No key is needed. 5) Do what we agreed, then check that the Stoolap MCP tools really show up.

This message has no key in it. If a key is needed, the AI will ask you to paste it yourself into the file or the app’s field.

  1. Install Node.js (if you don’t have it)

    Already installed? Check first · Open Terminal, type this command and press Enter

    node -v
    • A version number such as v26.13.1 = installed, skip this step
    • "command not found" (on Windows: "is not recognized") = not installed yet, or installed but Terminal needs to be closed and reopened
    How to open Terminal

    Mac: press ⌘ + Space, type Terminal, press Enter

    Windows: open Start, type Windows PowerShell, then Open

    Not installed: Open the official download page, pick the LTS version and the click-through installer: .pkg on Mac · .msi on Windows. Double-click and follow it to the end. No curl command needed

    Open the Node.js download page ↗

    When it’s done, close Terminal, open it again and run the same command. You should see a version number: node -v

    Install once; it works for everything that needs Node.js

  2. Open the Claude desktop app’s settings file

    SettingsDeveloperEdit Config

  3. Paste these settings and save the file

    {
      "mcpServers": {
        "stoolap": {
          "command": "npx",
          "args": [
            "-y",
            "@stoolap/mcp"
          ]
        }
      }
    }
  4. Quit Claude and open it again

  5. Try it

    Use Stoolap MCP and tell me what you can do for me, then show me one thing

    ✓ If Claude says it is using Stoolap MCP or shows a Stoolap MCP tool in the answer, you are connected

Menu names checked against Anthropic’s help page on Nov 11, 2026 · your screen may differ slightly by app version

ChatGPT cannot connect Stoolap MCP yet

Stoolap MCP runs on your computer, but ChatGPT can only connect servers that run on the web

What you can do instead

A · Use an app that can connect Stoolap MCP

  • Install Node.js on your computer first (one time) · Only the Claude desktop app (Windows or Mac), not the web or phone
  • Install Node.js on your computer first (one time)
  • Install Node.js on your computer first (one time)
  • Install Node.js on your computer first (one time)

B · Others in Search & AI memory that work with ChatGPT

Picked from the most used in the same category, only ones that connect by address with no key

Works with Claude Code, with some setup first

Install Node.js on your computer first (one time)

Let AI install it

Copy this message into a Claude Code chat. The AI checks your computer, tells you which file it will change, and waits for your OK every time.

Please install the MCP server Stoolap MCP for Claude Code on this computer, in this order: 1) Check Node.js with node -v. If it is missing, tell me to install it from https://nodejs.org/en/download; do not install it yourself. 2) Use only this config (already checked by PopNx MCP): claude mcp add --scope user stoolap -- npx -y @stoolap/mcp 3) Tell me the full path of the file you will change, or the command you will run, and wait for my OK. 4) No key is needed. 5) Do what we agreed, then check that the Stoolap MCP tools really show up.

This message has no key in it. If a key is needed, the AI will ask you to paste it yourself into the file or the app’s field.

  1. Install Node.js (if you don’t have it)

    Already installed? Check first · Open Terminal, type this command and press Enter

    node -v
    • A version number such as v26.13.1 = installed, skip this step
    • "command not found" (on Windows: "is not recognized") = not installed yet, or installed but Terminal needs to be closed and reopened
    How to open Terminal

    Mac: press ⌘ + Space, type Terminal, press Enter

    Windows: open Start, type Windows PowerShell, then Open

    Not installed: Open the official download page, pick the LTS version and the click-through installer: .pkg on Mac · .msi on Windows. Double-click and follow it to the end. No curl command needed

    Open the Node.js download page ↗

    When it’s done, close Terminal, open it again and run the same command. You should see a version number: node -v

    Install once; it works for everything that needs Node.js

  2. Open Terminal

    Mac: press Command+Space and type Terminal · Windows: open PowerShell

  3. Paste this command and press Enter

    claude mcp add --scope user stoolap -- npx -y @stoolap/mcp
  4. Type /mcp in Claude Code

    You should see Stoolap MCP listed as connected

  5. Try it

    Use Stoolap MCP and tell me what you can do for me, then show me one thing

    ✓ If Claude Code says it is using Stoolap MCP or shows a Stoolap MCP tool in the answer, you are connected

Menu names checked against Anthropic’s help page on Nov 11, 2026 · your screen may differ slightly by app version

Works with Cursor, with some setup first

Install Node.js on your computer first (one time)

Let AI install it

Copy this message into a Cursor chat. The AI checks your computer, tells you which file it will change, and waits for your OK every time.

Please install the MCP server Stoolap MCP for Cursor on this computer, in this order: 1) Check Node.js with node -v. If it is missing, tell me to install it from https://nodejs.org/en/download; do not install it yourself. 2) Use only this config (already checked by PopNx MCP): { "mcpServers": { "stoolap": { "command": "npx", "args": [ "-y", "@stoolap/mcp" ] } } } 3) Tell me the full path of the file you will change, or the command you will run, and wait for my OK. 4) No key is needed. 5) Do what we agreed, then check that the Stoolap MCP tools really show up.

This message has no key in it. If a key is needed, the AI will ask you to paste it yourself into the file or the app’s field.

  1. Install Node.js (if you don’t have it)

    Already installed? Check first · Open Terminal, type this command and press Enter

    node -v
    • A version number such as v26.13.1 = installed, skip this step
    • "command not found" (on Windows: "is not recognized") = not installed yet, or installed but Terminal needs to be closed and reopened
    How to open Terminal

    Mac: press ⌘ + Space, type Terminal, press Enter

    Windows: open Start, type Windows PowerShell, then Open

    Not installed: Open the official download page, pick the LTS version and the click-through installer: .pkg on Mac · .msi on Windows. Double-click and follow it to the end. No curl command needed

    Open the Node.js download page ↗

    When it’s done, close Terminal, open it again and run the same command. You should see a version number: node -v

    Install once; it works for everything that needs Node.js

  2. Click this button to open Cursor

    Open in Cursor

    Cursor asks you to confirm; click Install

  3. Open the AI chat in Cursor in Agent mode

  4. Try it

    Use Stoolap MCP and tell me what you can do for me, then show me one thing

    ✓ If Cursor says it is using Stoolap MCP or shows a Stoolap MCP tool in the answer, you are connected

Menu names checked against Cursor’s help page on Nov 11, 2026 · your screen may differ slightly by app version

Works with VS Code, with some setup first

Install Node.js on your computer first (one time)

Let AI install it

Copy this message into a VS Code chat. The AI checks your computer, tells you which file it will change, and waits for your OK every time.

Please install the MCP server Stoolap MCP for VS Code on this computer, in this order: 1) Check Node.js with node -v. If it is missing, tell me to install it from https://nodejs.org/en/download; do not install it yourself. 2) Use only this config (already checked by PopNx MCP): { "servers": { "stoolap": { "type": "stdio", "command": "npx", "args": [ "-y", "@stoolap/mcp" ] } } } 3) Tell me the full path of the file you will change, or the command you will run, and wait for my OK. 4) No key is needed. 5) Do what we agreed, then check that the Stoolap MCP tools really show up.

This message has no key in it. If a key is needed, the AI will ask you to paste it yourself into the file or the app’s field.

  1. Install Node.js (if you don’t have it)

    Already installed? Check first · Open Terminal, type this command and press Enter

    node -v
    • A version number such as v26.13.1 = installed, skip this step
    • "command not found" (on Windows: "is not recognized") = not installed yet, or installed but Terminal needs to be closed and reopened
    How to open Terminal

    Mac: press ⌘ + Space, type Terminal, press Enter

    Windows: open Start, type Windows PowerShell, then Open

    Not installed: Open the official download page, pick the LTS version and the click-through installer: .pkg on Mac · .msi on Windows. Double-click and follow it to the end. No curl command needed

    Open the Node.js download page ↗

    When it’s done, close Terminal, open it again and run the same command. You should see a version number: node -v

    Install once; it works for everything that needs Node.js

  2. Click this button to open VS Code

    Open in VS Code

    VS Code asks you to confirm; click Install

  3. Open the AI chat in VS Code in Agent mode

  4. Try it

    Use Stoolap MCP and tell me what you can do for me, then show me one thing

    ✓ If VS Code says it is using Stoolap MCP or shows a Stoolap MCP tool in the answer, you are connected

Menu names checked against VS Code’s help page on Nov 11, 2026 · your screen may differ slightly by app version

Other apps that use MCP, such as Windsurf, Zed or Gemini CLI, each add servers differently. See how in the app list.

See every app that uses MCP →

JSON settings are under “For developers” below

Stuck? Ask people who use Stoolap MCP💬 Discussion →
For developers: Terminal commands and JSON settings

Installed on your computer

Claude Code

claude mcp add --scope user stoolap -- npx -y @stoolap/mcp

Claude Desktop (claude_desktop_config.json)

{
  "mcpServers": {
    "stoolap": {
      "command": "npx",
      "args": [
        "-y",
        "@stoolap/mcp"
      ]
    }
  }
}

Cursor (~/.cursor/mcp.json)

{
  "mcpServers": {
    "stoolap": {
      "command": "npx",
      "args": [
        "-y",
        "@stoolap/mcp"
      ]
    }
  }
}

VS Code (mcp.json)

{
  "servers": {
    "stoolap": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@stoolap/mcp"
      ]
    }
  }
}

These settings are generated from the maker’s registry entry. If the README says otherwise, follow the README.

At a glance

Downloads per weeki
8/wk
Licencei
Apache-2.0
Connection
Runs on your computer
Latest versioni
0.5.0
Published to registryi
Nov 18, 2026
Code last changedi
Nov 18, 2026
Maker
stoolap
Packages
npm: @stoolap/mcp
Registry status
Active

Which apps can use it

Based on how this server connects and on each app’s own docs, checked Nov 10, 2026.

Run on your computer in

ClaudeGooseLM StudioMsty StudioCherry StudioCursorVS Code + GitHub CopilotVisual StudioWindsurf (Devin Desktop)ZedKiroClineContinueJetBrains AI AssistantClaude CodeCodex CLIGemini CLIOpenCodenodecodeWarpLibreChatRaycast

All apps, with pros and cons →

Related guides

What it can do

Runs on your computer; the tool list appears in your AI app after you install it.

Basic checksi

We check information anyone can see; we have not read the code. Checks that do not apply are left out of the count. · Checked Nov 21, 2026

  • ✓ Pass

    Maker matches the repo

    The registry name was verified with the GitHub account stoolap, which owns the repo

  • ✓ Pass

    Still maintained

    Code last changed 3 days ago

  • ✓ Pass

    Has a licence

    Uses Apache-2.0

  • – Not applicable

    Endpoint responds

    This one runs on your computer; there is no internet endpoint

  • – Not applicable

    Sign-in with OAuth

    Runs on your computer and uses local settings instead

  • … Not checked yet

    No hidden instructions in tool descriptions

    Runs on your computer; we can only read tool lists from internet endpoints

Published vulnerabilities (OSV.dev)

No entries on OSV.dev for @stoolap/mcp@0.5.0

Checks only this package version, not every dependency · checked Nov 18, 2026

What we check → · JSON

Makers: ask for a re-check or report wrong info
For makers: add a badge to your README

If you made this, paste this code into your README. The badge links back to this page.

[![Featured on PopNx MCP](https://mcp.popnx.com/badge/stoolap-mcp.svg)](https://mcp.popnx.com/en/servers/stoolap-mcp)

Discussion

Ask, share a tip or report that it does not work. Sorted by what people marked helpful.

No posts yet. Be the first to ask or share.

Posts here are written by users, not the PopNx team.

Sign in to post

User reviews

No reviews yet

Sign in to write a review

Compared with others in Search & AI memoryi

  • More stars than 77% of the other 6535 servers in this category
  • Published to the registry more recently than 93% of the other 6535 servers in this category
  • Basic checks equal to or better than 99% of the other 6535 servers in this category

Compared with every active server in this category in the registry. Stars count only when the publisher owns the repo.

Common questions

Is Stoolap MCP safe?

It passed 3 of 3 applicable basic checks. We have not read the code. Before adding a key or token, see what access the server asks for and use a key with only the permissions you need.

What keys or codes does it need?

The registry does not list a required key, though some servers ask you to sign in on first use.

Does it run on my computer or in the cloud?

It runs on your computer. Your AI app starts it when needed, and data does not pass through the maker’s servers (unless it calls an online service itself).

Is it still maintained?

The GitHub repo last changed 3 days ago, and the latest version (0.5.0) reached the registry 3 days ago.

Which apps can use it?

Apps that support MCP, such as Claude Desktop, Claude Code, Cursor and VS Code. You also need Node.js on your computer.

What can I use instead?

In the same category: OpenSEO, Exa, Microsoft Learn MCP, Docs, COTAL actions (cotal.ai)

Similar alternatives

Same category, other makers, commands already checked. Official ones first, then by stars.

Reading a card:↓ Downloads per weeki★ GitHub starsiThree pillars: reviews · checks · usageiUpdated = latest version published to the registryi

OpenSEO

Keyword research, site audits, rank tracking and AI visibility for your AI agent.

by every-appWidely used★ 28.4KUpdated 7 days ago

Runs in the cloud✓ everyapp.com

Exa

Official Exa MCP for web search, content fetching, and multi-step research.

by exa-labsWidely used★ 5.2KUpdated yesterday

Runs in the cloud✓ service owner · exa.aiTried by the PopNx team

Microsoft Learn MCP

Official Microsoft Learn MCP Server – real-time, trusted docs & code samples for AI and LLMs.

by MicrosoftDocsWidely used★ 2KUpdated 12 months ago

Runs in the cloud✓ service owner · microsoft.comTried by the PopNx team

Docs

Search and read Empryo's documentation. Read-only, no auth, no local access.

by proxysoulGrowing★ 1.6KUpdated 3 months ago

Runs in the cloud✓ empryo.com
Compared with similar ones
This one
Stoolap MCP
OpenSEOExaMicrosoft Learn MCPDocsCOTAL actions (cotal.ai)
Runs whereInstalls on your computerRuns in the cloud, nothing to installRuns in the cloud, nothing to installRuns in the cloud, nothing to installRuns in the cloud, nothing to installRuns in the cloud, nothing to install
Needs a keyNoNoNoNoNoNo
Add with + in ClaudeNoYesYesYesNoNo
Basic checks3/35/52/44/44/44/4
LicenseApache-2.0MITMITCC-BY-4.0NOASSERTIONApache-2.0
PriceNo cost listed in the registryNo cost listed in the registryNo cost listed in the registryNo cost listed in the registryNo cost listed in the registryNo cost listed in the registry

README from the maker

Open the README

Copied from the maker’s repo as written. PopNx MCP has not reviewed or endorsed it. HTML, images and scripts are removed. Links lead off this site.

stoolap-mcp

An MCP (Model Context Protocol) server for Stoolap, an embedded SQL database written in Rust. It lets an AI assistant inspect a schema, run queries, write data inside transactions, read query plans and check the health of a database file.

It works with any MCP client that speaks stdio: Claude Desktop, Claude Code, Cursor, Windsurf, Cline and others.

Version 0.5 of this server targets the Stoolap 0.5 engine through @stoolap/node 0.5.

Quick start

Claude Code
claude mcp add stoolap -- npx -y @stoolap/mcp --path ./mydata
Claude Desktop and other JSON-configured clients

On macOS the Claude Desktop file is ~/Library/Application Support/Claude/claude_desktop_config.json.

{

"mcpServers": { "stoolap": { "command": "npx", "args": ["-y", "@stoolap/mcp", "--path", "./mydata"] } } }

Leave out --path for an in-memory database that disappears when the server stops. Add "--read-only" to the arguments to let the assistant read but never write.

The first npx run compiles the small native addon of @stoolap/node. A client with a short startup timeout may report a failed connection on that first run; retry once the install has finished, or install the package globally first (npm install -g @stoolap/mcp).

Docker
docker build -t stoolap-mcp .

docker run -i --rm -v "$PWD/data:/data" stoolap-mcp --path /data/mydb

The server talks over stdio, so the container must run with -i.

Options

FlagDefaultDescription
--path :memory:Database path or DSN. Engine options go in the query string, e.g. ./mydata?sync_mode=full&checkpoint_interval=30.
--read-onlyoffRefuse every statement that writes data, schema or engine settings. Reads and read-only transactions still work.
--max-rows 1000The most rows one call returns. Longer results come back cut, with truncated: true. A call can ask for fewer with max_rows, never for more. 0 removes the limit.
--query-timeout 30000Stop any statement that runs longer, with the error query cancelled. 0 turns it off. Without the flag, a query_timeout in the DSN is used instead of the default.
--versionPrint the server version and exit.

Tools (14)

Every tool carries MCP annotations (readOnlyHint, destructiveHint), so a client can approve the read-only ones automatically.

SQL
ToolWhat it does
queryRuns one read-only statement: SELECT, WITH ... SELECT, SHOW, DESCRIBE, EXPLAIN.
executeRuns one statement that writes: INSERT, UPDATE, DELETE, COPY, CREATE, ALTER, DROP, TRUNCATE, ANALYZE, VACUUM, SET. Returns {"affected_rows": n}, or rows when the statement has RETURNING.
execute_batchRuns one INSERT, UPDATE or DELETE once per parameter set, all or nothing: when one set fails, none of them stays applied, inside a transaction too.
explainPrints the plan of a statement (given without EXPLAIN), one step per line. With analyze: true it runs the statement and shows actual time, rows and the paths taken; this is refused for anything but reads.

query and RETURNING return rows in one shape:

{"columns": ["id", "name"], "rows": [[1, "alice"], [2, "bob"]], "row_count": 2, "truncated": false}

Columns keep their order and duplicate names (SELECT a.id, b.id), and an empty result still lists its columns. VECTOR values are arrays of numbers, and the FLOAT values NaN, Infinity and -Infinity are the strings "NaN", "Infinity" and "-Infinity", because JSON has no way to write them.

Parameters are an array for $1, $2 or ? placeholders, or an object for :name placeholders. JSON and VECTOR values are passed as text.

Two limits come from the Node.js driver, and the instructions tell the assistant about both:

  • INTEGER values travel as JavaScript numbers, which are exact only up to 2^53. A larger parameter is refused with a hint to pass it as a string, which the engine converts exactly; read large values with CAST(x AS TEXT).
  • TIMESTAMP values come back as ISO 8601 strings to the millisecond. CAST(ts AS TEXT) gives all nine digits.
Transactions
ToolWhat it does
begin_transactionOpens a transaction, read_committed (default) or snapshot.
commit_transactionCommits it.
rollback_transactionRolls it back.
savepointcreate, rollback_to or release a named savepoint.

While a transaction is open, query, execute and execute_batch run inside it and see its uncommitted rows. There is one transaction at a time, on the server's single connection.

Schema
ToolWhat it does
list_tablesThe names of all tables and views.
get_schemaCREATE TABLE for every table (or the one table or view named) with constraints and foreign keys, a line per secondary index, and CREATE VIEW for every view.

Both leave out the _sys_table_stats and _sys_column_stats tables in which ANALYZE keeps optimizer statistics.

Engine
ToolWhat it does
pragmaReads or changes an engine setting, reads a report, or runs a maintenance action (see below).
verifyReads every column volume of a file database, checks each block's checksum, and reports each segment as ok, damaged, unreadable or failed. It changes nothing.
list_functionsEvery built-in SQL function with its signature and semantics, by category.
versionEngine and server versions, the read-only flag, row limit and query timeout in effect, and the isolation level of the open transaction (null when none is open).

pragma accepts these names:

  • Settings (integer; omit the value to read): checkpoint_interval, compact_threshold, target_volume_rows, keep_snapshots, hot_max_rows, hot_max_bytes, group_cache_mb, index_cache_mb, index_build_mb, query_timeout (milliseconds, this connection only).
  • Reports: sync_mode, wal_flush_trigger, volume_stats, memory_stats, group_cache_stats, index_stats, index_read_stats. PRAGMA VERIFY is the verify tool.
  • Actions: checkpoint, snapshot, vacuum, index_backfill (value: the most volumes to build), restore (value: a snapshot timestamp such as 20260315-120000.000, the latest when omitted; it replaces all data).

Instructions, resources and prompt

The server sends MCP instructions when a client connects: which tool to use for what, the result shape, the SQL rules most likely to surprise (comparison of TEXT with numbers, overflow errors, strict name resolution, DDL in transactions) and what Stoolap does not support.

URI or nameContent
stoolap://schemaThe live schema, as returned by get_schema.
stoolap://sql-referenceThe live schema plus the complete Stoolap 0.5 SQL reference and every function.
sql-assistant (prompt)The same content as stoolap://sql-reference, for clients that take prompts rather than resources.

Safety

  • Read-only mode. The Stoolap engine has no read-only open mode, so the server enforces it: in --read-only every statement that writes is refused before it reaches the engine, including COPY, DDL, SET, ANALYZE, VACUUM, EXPLAIN ANALYZE of anything but a read, and every pragma action and setting, query_timeout included.
  • SQL is read the way the engine reads it. The checks tokenize SQL like the engine lexer: string escapes, quoted identifiers, --, # and /* */ comments, and every Unicode whitespace character. They judge the statement that is actually sent, after EXPLAIN [ANALYZE], and find the main verb of a WITH at its own depth. A NUL character or a byte order mark is refused.
  • One statement per call. The engine runs every statement of a multi-statement string and reports only the last, so a second statement is refused.
  • Tool routing. query takes only reads and execute only writes. Transaction control statements (BEGIN, COMMIT, ROLLBACK, SAVEPOINT, RELEASE) are refused in SQL and run only through the transaction tools, so the server always knows whether a transaction is open.
  • DDL inside a transaction. The engine rolls back a plain CREATE TABLE made in a transaction, but CREATE TABLE ... AS SELECT, ALTER TABLE, CREATE INDEX and CREATE VIEW persist after ROLLBACK, and DROP TABLE and TRUNCATE lose rows. The server refuses all of those but the plain CREATE TABLE while a transaction is open.
  • Isolation. begin_transaction always names its level, so a SET isolation_level run earlier cannot change what it opens.
  • Limits. The row limit keeps one call from returning millions of rows, and the query timeout keeps it from running forever. A cancelled statement changes nothing and the connection stays usable. The driver has no raw cursor yet, so the server still reads the whole result before cutting it; the timeout bounds that work.
  • One call at a time. Clients may send requests concurrently; the server runs them one after another, so statements of one transaction never interleave.
  • COPY ... FROM reads files on the host with the server process's permissions, so an assistant can load any file the process can read. Run with --read-only when that is not acceptable.
  • Names and values. Table names are quoted, savepoint names must be plain identifiers, and pragma names and values are checked before they reach SQL.
  • When the client disconnects or the process gets SIGINT, SIGTERM or SIGHUP, an open transaction is rolled back and the database is closed cleanly.

Upgrading from 0.4

  • The 30 tools became 14. transaction_query, transaction_execute and transaction_execute_batch are gone: query, execute and execute_batch run inside the open transaction. create_table, create_index, create_view, alter_table, drop, analyze_table and vacuum are statements for execute. list_views is part of list_tables; describe_table, show_create_table, show_create_view and show_indexes are covered by get_schema and by query with SHOW and DESCRIBE. savepoint, rollback_to_savepoint and release_savepoint are one savepoint tool with an action.
  • Rows come back as {columns, rows, row_count, truncated} instead of an array of objects, and writes as {"affected_rows": n}.
  • explain takes the statement without the EXPLAIN keyword.
  • --read-only was not airtight in 0.4: a # line comment could hide a second statement from the check. Upgrade if you rely on it.
  • Results stop at 1,000 rows and statements at 30 seconds by default.
  • stoolap://schema is DDL text instead of JSON.
  • Stoolap 0.5 opens a 0.4 database without a manual step and moves its format forward as it runs; 0.4 cannot open it afterwards. Back up the directory first; the engine's migration guide lists every answer that changed.

Requirements

  • Node.js 20 or later.
  • @stoolap/node 0.5, installed automatically, with prebuilt engine libraries for Linux (x64, arm64), macOS (x64, arm64) and Windows (x64). Its small N-API addon needs a C compiler at install time.

Development

git clone https://github.com/stoolap/stoolap-mcp.git

cd stoolap-mcp npm install npm test # builds, then runs the unit tests and the end-to-end tests against the built server node build/index.js --path ./mydata

The source is split by concern: src/cli.ts (arguments), src/sql.ts (statement checks), src/session.ts (the connection, transaction state and result conversion), src/server.ts (tools, resources and prompt) and src/reference.ts (the texts sent to the ass

Only the beginning is shown; read the rest in the repo