
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 toolsPublic 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
Details
- Repository
- github.com/cocaxcode/database-mcp
- Category
- Databases
- Package
@cocaxcode/database-mcp- Transport
- STDIO
- Registry
- MCP registry, active