cocaxcode avatar

Database Mcp

cocaxcode/database-mcp

A full database workbench that connects PostgreSQL, MySQL, and SQLite through 33 natural language tools. You get connection groups scoped to project directories, automatic schema discovery via MCP Resources, pre-mutation snapshots with rollback, dump and restore, and per-project query history. Every connection lives in a group with default and active states, so switching from dev to prod for a quick query won't leave you there on restart. The AI reads foreign keys from your schema and builds JOINs automatically. Works with Claude Code, Claude Desktop, Cursor, Windsurf, VS Code, and any MCP client. Credentials stay local, drivers load dynamically at runtime.

GitHub stars
1
tools
31
transport
STDIO
last updated
Mar 25, 2026

Tools

31 tools

Public tool metadata for what this MCP can expose to an agent.

conn_createCreate a named database connection.

Create a named database connection.

No parameter schema in public metadata yet.

conn_listList connections.

List connections.

No parameter schema in public metadata yet.

conn_getShow connection details with passwords masked.

Show connection details with passwords masked.

No parameter schema in public metadata yet.

conn_setUpdate connection settings.

Update connection settings.

No parameter schema in public metadata yet.

conn_switchSwitch the active connection.

Switch the active connection.

No parameter schema in public metadata yet.

conn_renameRename a connection.

Rename a connection.

No parameter schema in public metadata yet.

conn_deleteDelete a connection.

Delete a connection.

No parameter schema in public metadata yet.

conn_duplicateDuplicate a connection.

Duplicate a connection.

No parameter schema in public metadata yet.

conn_testTest a connection.

Test a connection.

No parameter schema in public metadata yet.

conn_exportExport connections as JSON.

Export connections as JSON.

No parameter schema in public metadata yet.

conn_importImport connections from JSON.

Import connections from JSON.

No parameter schema in public metadata yet.

conn_group_createCreate a connection group.

Create a connection group.

No parameter schema in public metadata yet.

conn_group_listList connection groups.

List connection groups.

No parameter schema in public metadata yet.

conn_group_deleteDelete a connection group.

Delete a connection group.

No parameter schema in public metadata yet.

conn_group_add_scopeAdd a directory scope to a group.

Add a directory scope to a group.

No parameter schema in public metadata yet.

conn_group_remove_scopeRemove a directory scope from a group.

Remove a directory scope from a group.

No parameter schema in public metadata yet.

conn_set_defaultSet the default connection.

Set the default connection.

No parameter schema in public metadata yet.

conn_set_groupAssign a connection to a group.

Assign a connection to a group.

No parameter schema in public metadata yet.

search_schemaSearch database schema.

Search database schema.

No parameter schema in public metadata yet.

execute_queryExecute a read query with automatic LIMIT.

Execute a read query with automatic LIMIT.

No parameter schema in public metadata yet.

execute_mutationExecute a data-modifying statement with rollback snapshots.

Execute a data-modifying statement with rollback snapshots.

No parameter schema in public metadata yet.

explain_queryShow the execution plan for a query.

Show the execution plan for a query.

No parameter schema in public metadata yet.

db_dumpDump the database to a SQL file.

Dump the database to a SQL file.

No parameter schema in public metadata yet.

db_restoreRestore the database from a dump.

Restore the database from a dump.

No parameter schema in public metadata yet.

db_dump_listList available dumps.

List available dumps.

No parameter schema in public metadata yet.

rollback_listList available rollback snapshots.

List available rollback snapshots.

No parameter schema in public metadata yet.

rollback_applyApply a rollback snapshot.

Apply a rollback snapshot.

No parameter schema in public metadata yet.

history_listList query history.

List query history.

No parameter schema in public metadata yet.

history_clearClear query history.

Clear query history.

No parameter schema in public metadata yet.

config_getGet configuration values.

Get configuration values.

No parameter schema in public metadata yet.

config_setSet configuration values.

Set configuration values.

No parameter schema in public metadata yet.

Sponsors

Readme

@cocaxcode/database-mcp

Your databases, one conversation away.
33 tools · PostgreSQL · MySQL · SQLite · Connection Groups · Rollback · Dump/Restore · Schema auto-discovery

npm version npm downloads License Node 33 tools


View the full README on GitHub

Details

Repository
github.com/cocaxcode/database-mcp
Category
Databases
Package
@cocaxcode/database-mcp
Transport
STDIO
Registry
MCP registry, active

More from cocaxcode

Related Databases MCP servers

View all
1infoinlet-marketplace avatarMcp Mysqlinfoinlet-marketplace/marketplaceRead-only MySQL/MariaDB for AI agents — query, list/describe tables, health. SQL-guarded.0stars
2yash-0620 avatarPostgres Secured (Aegis Zero-Trust)yash-0620/postgres-mcpEnterprise PostgreSQL MCP secured by Aegis Zero-Trust to block unauthorized SQL injections.0stars
3neverinfamous avatarPostgreSQL MCP Serverneverinfamous/postgresql-mcpPostgreSQL MCP server with 203 tools, connection pooling, HTTP/SSE, OAuth 2.1, and tool filtering8stars
4timescale avatarPg Aiguidetimescale/pg-aiguideComprehensive PostgreSQL documentation and best practices, including ecosystem tools1.9Kstars
5neondatabase avatarNeonneondatabase/mcp-server-neonOfficial Neon MCP server for managing Neon projects and Lakebase Postgres databases.663stars
6yawlabs avatarPostgreSQL MCP Serveryawlabs/postgres-mcpPostgreSQL MCP server - query, schema introspection, explain, and health checks for AI assistants10stars