neosql-mcp
This server bridges AI coding assistants (and other MCP hosts) with NeoSQL Desktop, giving them access to your real database connections, schemas, and query execution capabilities over npx.
ping– Lightweight health check; returnspongto verify the server is running.getMcpSessionId– Retrieve the upstream MCP session ID for diagnostics.listConnections– Discover all MCP-enabled database connections and schemas, including DBMS family, database version, environment profile, and per-schema policies.getContextHelp– Get guidance on how to find and configure NeoSQL project and connection IDs.listTables– List all tables and views in a schema, with optional keyword filtering by name or comment.getTableDetails– Retrieve detailed metadata for one or more tables: columns, primary keys, foreign keys, indexes, and constraints.executeQuery– Run SQL queries (SELECT, INSERT, UPDATE, DELETE, EXPLAIN) against your database. DDL statements are intentionally blocked; returns up to 200 rows for SELECT/EXPLAIN.createTables– Create new tables with columns, primary keys, foreign keys, indexes, and constraints (UNIQUE, CHECK, EXCLUSION).modifyTables– Alter existing tables: rename, change comments, and add/drop/modify columns, indexes, foreign keys, primary keys, and constraints.generateCode– Generate source code files from a database table using a specified NeoSQL template pack.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@neosql-mcplist tables in the sales schema"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
neosql-mcp
Bring NeoSQL Desktop's database tools into your MCP host (Claude Code, Codex, …) via
npx.
neosql-mcp is a local stdio MCP server that lets MCP hosts use NeoSQL Desktop
tools through npx.
It is not a standalone database server, database CLI, or replacement for NeoSQL Desktop. The package runs inside the MCP host process tree, exposes NeoSQL tools over standard MCP stdio, and delegates database/UI work to a running NeoSQL Desktop app through JSON-RPC over HTTP on a macOS Unix Domain Socket or Windows Named Pipe.
[MCP host] -- stdio MCP --> [neosql-mcp]
-- JSON-RPC over HTTP on UDS/Named Pipe --> [NeoSQL Desktop]Why neosql-mcp?
AI coding assistants write better code when they can read your real schema and run real queries, instead of guessing column names and table shapes. neosql-mcp exposes the database your team already configured in NeoSQL Desktop to any MCP host.
One running NeoSQL Desktop, one npx command — Claude Code, Codex, and any other MCP host can use the connections and schemas already configured in NeoSQL Desktop. No per-host setup, and credentials never leave NeoSQL Desktop.
Security
All traffic stays on the local machine over a Unix Domain Socket (macOS) or Named Pipe (Windows). No TCP ports are opened, and the upstream endpoint cannot be overridden by environment variables or config files. Database access scope follows the connection settings in NeoSQL Desktop — credentials and per-connection permissions are not duplicated here.
Prerequisites
Node.js 20 or later.
NeoSQL Desktop installed on the same machine.
An MCP host that can launch stdio servers, such as Claude Code or Codex.
A NeoSQL project with MCP-enabled database connections and schemas.
Quick Start
No global install is required. Configure your MCP host to run the package with npx.
npx -y neosql-mcp \
--project=YOUR_PROJECT_ID \
--default-connection=YOUR_CONNECTION_ID \
--default-schema=YOUR_SCHEMAThe process is a stdio MCP server, so running the command directly in a terminal may look like it is waiting for input. That is expected.
MCP Host Configuration
Claude Code .mcp.json
{
"mcpServers": {
"neosql": {
"command": "npx",
"args": [
"-y",
"neosql-mcp",
"--project=YOUR_PROJECT_ID",
"--default-connection=YOUR_CONNECTION_ID",
"--default-schema=YOUR_SCHEMA"
]
}
}
}Codex config.toml
[mcp_servers.neosql]
command = "npx"
args = [
"-y",
"neosql-mcp",
"--project=YOUR_PROJECT_ID",
"--default-connection=YOUR_CONNECTION_ID",
"--default-schema=YOUR_SCHEMA",
]CLI Options
Option | Description |
| Sets the default NeoSQL project id for tool calls. |
| Sets the default connection id. |
| Sets the default schema name. |
Use the --key=value form in MCP host config. Space-separated forms such as
--project value are intentionally not supported.
Context Resolution
NeoSQL tools resolve project, connection, and schema in this order:
Explicit arguments on the tool call.
The Node-local context store (set from CLI options at startup; restart to change).
Empty context.
Tools that accept per-call connectionId and schema overrides:
list-tablesget-table-detailsexecute-querycreate-tablesmodify-tables
Available Tools
Tool | Purpose |
| Returns |
| Lists MCP-enabled NeoSQL connections and schemas for the current project. |
| Explains how to find and configure NeoSQL context values. |
| Lists tables for the selected connection/schema. |
| Returns columns, keys, indexes, and related table metadata. |
| Executes non-DDL SQL using the selected context. |
| Requests table creation through NeoSQL Desktop. |
| Requests table modification through NeoSQL Desktop. |
| Diagnostic tool that returns the upstream session id used by this process. |
Transport
neosql-mcp talks to NeoSQL Desktop through a deterministic local endpoint:
macOS:
path.join(os.tmpdir(), 'neosql-mcp.sock')Windows:
\\.\pipe\neosql-mcp
Troubleshooting
NeoSQL Desktop was not found
Install NeoSQL Desktop first. On macOS, neosql-mcp currently checks the standard
/Applications and ~/Applications locations first. If the app is not found there,
it falls back to the app path recorded by NeoSQL Desktop in
~/.neosql/mcp-config.json after the app has been launched at least once. On
Windows, it checks the per-user NSIS uninstall registry entry under HKCU.
NeoSQL Desktop is not running
Start NeoSQL Desktop, wait for it to finish loading, and run the tool again. When
possible, neosql-mcp requests OS-level app activation before returning this state.
NeoSQL Desktop did not respond
The app may still be starting or blocked. Wait a moment and retry, or restart NeoSQL Desktop.
Context-sensitive tools fail
Run list-connections or get-context-help, then check that --project,
--default-connection, and --default-schema match an MCP-enabled connection/schema.
npx cannot find or run the package
Check that the MCP host can access npx, that Node.js is 20 or later, and that each CLI
option is a separate item in the MCP host args array.
Development
npm ci
npm run build
npm testFor local MCP host testing, build and link the binary:
npm run build
npm link
ls -la $(which neosql-mcp)When local testing is done, unlink it so direct neosql-mcp commands no longer use the
workspace build:
npm unlink -g neosql-mcpResources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/unvus/neosql-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server