mcp-db-analyzer
A Model Context Protocol (MCP) server that gives AI assistants deep visibility into databases, inspecting schemas, detecting index problems, analyzing table bloat, and explaining query plans across PostgreSQL, MySQL, and SQLite.
Install
npx -y mcp-db-analyzer
Paste the configuration above into your MCP client config (claude_desktop_config.json for Claude Desktop) and restart the client.
{
"mcpServers": {
"mcp-db-analyzer": {
"command": "npx",
"args": [
"-y",
"mcp-db-analyzer"
],
"env": {
"PGHOST": "<PGHOST>",
"PGPORT": "<PGPORT>",
"PGUSER": "<PGUSER>",
"DB_DRIVER": "<DB_DRIVER>",
"MYSQL_HOST": "<MYSQL_HOST>",
"MYSQL_PORT": "<MYSQL_PORT>",
"MYSQL_USER": "<MYSQL_USER>",
"PGDATABASE": "<PGDATABASE>"
}
}
}
}Paste the configuration above into your MCP client config (claude_desktop_config.json for Claude Desktop) and restart the client.
Sources: public MCP Server directories. This is an independent third-party directory with no affiliation to or endorsement from the maintainers of the listed servers.