PostgreSQL MCP Server
JSON →An MCP server that provides tools to interact with PostgreSQL databases.
Tools · 7
- postgres_query Execute SELECT queries against the database
- postgres_list_tables List all tables in the database
- postgres_get_table_schema Get detailed schema information for a table
- postgres_get_relationships Get table relationships (FK, PK, constraints)
- postgres_suggest_joins Suggest JOIN queries based on relationships
- postgres_get_database_info Get database name and connection information
- postgres_connection_stats Get connection pool statistics and health info
Environment variables
POSTGRES_STAGING_JDBC_URLPOSTGRES_RELEASE_JDBC_URLPOSTGRES_PRODUCTION_JDBC_URL
Links
★ 1 GitHub stars