Provides read-only query execution and schema inspection for PostgreSQL databases.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type @ followed by the MCP server name and your instructions, e.g., "@postgres-mcp list all tables in the analytics database"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
PostgreSQL MCP server focused on read-only queries and schema inspection, with support for up to 3 named database connections.
pg_execute_query: validates and executes a single read-only SQL query.
pg_list_tables: lists user tables with size and row estimates.
pg_describe_table: describes columns, foreign keys, and indexes for a table.
All tools accept an optional database parameter. When omitted, the server uses the default configured database.
Related MCP server: PostgreSQL MCP Server
Copy .env.example to .env and choose one mode.
POSTGRES_DSN=postgresql://user:password@localhost:5432/app_dbSlot 1 is required and becomes the default alias. Slots 2 and 3 are optional.
POSTGRES_DB_1_NAME=main
POSTGRES_DB_1_DSN=postgresql://user:password@localhost:5432/app_db
POSTGRES_DB_2_NAME=analytics
POSTGRES_DB_2_DSN=postgresql://user:password@localhost:5432/analytics_db
POSTGRES_DB_3_NAME=billing
POSTGRES_DB_3_DSN=postgresql://user:password@localhost:5432/billing_dbPOOL_MIN_SIZE=1
POOL_MAX_SIZE=3
POOL_COMMAND_TIMEOUT=30
POOL_CONNECT_TIMEOUT=10
QUERY_STATEMENT_TIMEOUT_MS=10000
QUERY_LOCK_TIMEOUT_MS=1000
QUERY_IDLE_IN_TRANSACTION_TIMEOUT_MS=15000python -m pip install -r requirements.txt
python -m pip install -e ".[dev]"python server.py{
"mcpServers": {
"postgres": {
"command": "python",
"args": ["C:/path/to/axis-postgres-mcp/server.py"],
"env": {
"POSTGRES_DB_1_NAME": "main",
"POSTGRES_DB_1_DSN": "postgresql://user:password@host:5432/app_db",
"POSTGRES_DB_2_NAME": "analytics",
"POSTGRES_DB_2_DSN": "postgresql://user:password@host:5432/analytics_db"
}
}
}
}{
"sql": "SELECT id, email FROM users ORDER BY id DESC",
"limit": 50,
"format": "markdown",
"database": "main"
}{
"schema_name": "public",
"database": "analytics"
}The server only accepts a single validated read-only SQL statement for pg_execute_query.
Every tool runs inside a read-only transaction with local statement, lock, and idle-in-transaction timeouts.
The server sanitizes database errors before returning them to the MCP client.
Logs never include the full DSN or password.
You should still connect with a PostgreSQL role that only has SELECT and metadata access.
Recommended role setup:
CREATE ROLE mcp_reader WITH LOGIN PASSWORD 'secret';
GRANT CONNECT ON DATABASE app_db TO mcp_reader;
GRANT USAGE ON SCHEMA public TO mcp_reader;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO mcp_reader;Run the unit suite:
python -m pytestRun integration tests only when you have real database credentials available:
python -m pytest -m integrationThis server cannot be installed
Unclaimed servers have limited discoverability.
If you are the server author, to access and configure the admin panel.
Query PostgreSQL databases in plain English — LLM-generated, safety-validated SQL.
Comprehensive PostgreSQL documentation and best practices, including ecosystem tools
Connect to PlanetScale databases, branches, schema, query insights, and execute SQL
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/leduardoaraujo/postgressql-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server