Connect to PostgreSQL and Vertica to query data and test connections.
Copy the install command and let the AI configure it · recommended for beginners
No copy-paste install info for "mcp-postgres-server" yet — see the docs or source repo.
Please test the PostgreSQL database connection and return the connection status, server version, and current database name.
Returns whether the connection succeeded, plus a summary of database version and instance details.
List all tables in the public schema of the current database and include a short description for each table.
Outputs a table list, optionally including schema, table type, or usage notes.
Query the orders table for the last 30 days' total order count, total revenue, and daily aggregates, then present the results clearly.
Returns query results including summary metrics and a daily aggregated data table.
Connect to PostgreSQL via MCP for queries, schema inspection, and database changes.
Connect AI assistants to PostgreSQL for secure querying, management, and analysis.
Query PostgreSQL, inspect tables, and explore schemas through MCP clients.
Use natural language to query PostgreSQL, manage schemas, and inspect database stats.
Inspect PostgreSQL schemas and run read-only SQL queries through MCP tools.
Safely query and inspect PostgreSQL databases without enabling risky write operations by default.