The MCP PostgreSQL Analytics server provides advanced analytics capabilities for PostgreSQL databases, including smart schema exploration, query optimization, index suggestions, and natural language to SQL conversion. It is designed to enhance database performance and accessibility through AI-driven tools.
服务器配置
{
"mcpServers": {
"postgres": {
"command": "node",
"args": [
"/path/to/mcp-postgres-analytics/dist/index.js"
],
"env": {
"DATABASE_URL": "postgres://user:password@localhost:5432/mydb"
}
}
}
}