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.
Related MCP server: database-remote-mcp
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-mcpThe 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"]
}
}
}Codex config.toml
[mcp_servers.neosql]
command = "npx"
args = [
"-y",
"neosql-mcp",
]CLI Options
Option | Description |
| Connects to the matching NeoSQL Desktop profile. |
Use the --key=value form in MCP host config. Space-separated forms such as
--profile dev are intentionally not supported. The default profile is prod.
Context Resolution
NeoSQL tools always use the project currently selected and fully loaded in NeoSQL Desktop. The Node process does not store a project or default database coordinate.
Database tools accept coordinates in one of two forms:
Omit
connectionId,database, andschematogether to use the active project's Default selected in NeoSQL MCP Access Control.Pass all three values together to use an explicit MCP-enabled coordinate returned by
list-connections. Usedatabase: nullfor DBMSs without a database hierarchy.
Passing only one or two coordinate fields is invalid. Explicit coordinates never fall back to the project Default when they are invalid.
Tools that accept the complete explicit coordinate tuple:
list-tablesget-table-detailsexecute-querycreate-tablesmodify-tables
Available Tools
Tool | Purpose |
| Returns |
| Lists MCP-enabled NeoSQL connections and schemas for the current project. |
| Explains active-project Default and explicit coordinate usage. |
| Lists tables using the project Default or an explicit coordinate. |
| Returns columns, keys, indexes, and related table metadata. |
| Executes non-DDL SQL using the Default or an explicit coordinate. |
| 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
Select a project in NeoSQL Desktop and configure an enabled Default in MCP Access
Control. To use another coordinate, run list-connections and pass its connectionId,
databaseName, and schemaName values together as connectionId, database, and
schema.
npx cannot find or run the package
Check that the MCP host can access npx and that Node.js is 20 or later.
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-mcpMaintenance
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Related MCP Servers
- Alicense-qualityCmaintenanceEnables SQL query execution and database structure browsing via MCP tools and resources.MIT
- Flicense-qualityCmaintenanceEnables remote database access (RDBMS and MongoDB) through MCP tools, supporting read/write queries, schema management, and more.
- FlicenseAqualityCmaintenanceLocal stdio MCP server for read-only Microsoft SQL Server access through Python and pyodbc, providing test connection, list tables, describe table, and query tools.4
- FlicenseAqualityCmaintenanceProduction-oriented MCP server for Microsoft SQL Server, enabling query execution, database discovery, schema introspection, and metadata inspection via MCP clients.63
Related MCP Connectors
MCP server for managing Prisma Postgres.
MCP server for interacting with the Supabase platform
GibsonAI MCP server: manage your databases with natural language
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
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