Connect Claude to PostgreSQL databases for natural language data querying, schema exploration, and SQL generation.
npx -y @modelcontextprotocol/server-postgres postgresql://user:pass@localhost:5432/db
Paste this into your MCP client configuration (Cursor, Windsurf, etc).
Connect your AI assistant to PostgreSQL databases for powerful data interaction.
npx -y @modelcontextprotocol/server-postgres postgresql://user:pass@localhost:5432/mydb
Add to your Claude Desktop config:
{
"mcpServers": {
"postgres": {
"command": "npx",
"args": ["-y", "@modelcontextprotocol/server-postgres", "postgresql://..."]
}
}
}
MCP (Model Context Protocol) servers extend your AI assistant with external tools and data sources. Follow these steps to install PostgreSQL MCP Server in your preferred AI coding tool.
claude_desktop_config.jsonConnect to Supabase for database queries, auth, and storage operations.
Query and manage SQLite databases for local data storage and analysis.
Access and modify Airtable bases
Access MongoDB databases with document operations