Execute SQL queries, manage schemas, inspect tables, and interact with PostgreSQL databases. Supports parameterized queries and transactions.
Quick Install
npx @mcp/postgresqlClaude Desktop Config
{
"mcpServers": {
"postgresql-mcp": {
"command": "npx",
"args": [
"@mcp/postgresql"
]
}
}
}execute_query
Run SQL queries against the database
inspect_schema
View table schemas and relationships
manage_tables
Create and alter tables
v1.0.0
Initial release
database.readdatabase.writedatabase.admin