database MCP Server
A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.
Discovered via unknown and last synced 3mo ago.
1. Install the package
npx @benborla29/mcp-server-mysql
2. Add to claude_desktop_config.json
{
"mcpServers": {
"benborla29-mcp-server-mysql": {
"command": "npx",
"args": [
"@benborla29/mcp-server-mysql"
]
}
}
}Config file location: ~/Library/Application Support/Claude/claude_desktop_config.json (macOS) / %APPDATA%\Claude\claude_desktop_config.json (Windows)
default, limited to READ ONLY operations
Add new data to tables (requires `ALLOW_INSERT_OPERATION=true`)
prepared statements for secure parameter handling
Execute SQL queries against the connected database
query timeouts and result pagination
write operations (when enabled via configuration):
`sql` (string): The SQL query to execute
query execution statistics
Remove data (requires `ALLOW_DELETE_OPERATION=true`)
operations are executed within a transaction with proper commit/rollback handling
Modify existing data (requires `ALLOW_UPDATE_OPERATION=true`)
Use this skill when designing database schemas, optimizing queries, creating indexes, planning migrations, or choosing between database technologies. Triggers on schema design, normalization, indexing strategies, query optimization, EXPLAIN plans, migrations, partitioning, replication, connection pooling, and any task requiring database architecture or performance decisions.
database-admin workflow skill. Use this skill when the user needs Expert database administrator specializing in modern cloud databases, automation, and reliability engineering and the operator should preserve the upstream workflow, copied support files, and provenance before merging or handing off.
Database Workflow Bundle workflow skill. Use this skill when the user needs Database development and operations workflow covering SQL, NoSQL, database design, migrations, optimization, and data engineering and the operator should preserve the upstream workflow, copied support files, and provenance before merging or handing off.
AppDeploy Skill workflow skill. Use this skill when the user needs Deploy web apps with backend APIs, database, and file storage. Use when the user asks to deploy or publish a website or web app and wants a public URL. Uses HTTP API via curl and the operator should preserve the upstream workflow, copied support files, and provenance before merging or handing off.
open-source agentic AI data assistant for the next generation of AI + Data products.
MCP Toolbox for Databases is an open source MCP server for databases.
Data Agent Ready Warehouse : One for Analytics, Search, AI, Python Sandbox. — rebuilt from scratch. Unified architecture on your S3.
Second Brain is an agentic framework that acts as an operating system, using local file intelligence, workflow automation, and LLMs to complete tasks and communicate over multiple modalities and messaging platforms.
Learn how to use the database-engineering Claude skill. Complete guide with installation instructions and examples.
Learn how to use the azure-postgres-ts-v2 Claude skill. Complete guide with installation instructions and examples.
Learn how to use the database-architect-v3 Claude skill. Complete guide with installation instructions and examples.