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"
}
}
}
}