$ loading_
Turn PostgreSQL databases into REST APIs for schema discovery, CRUD, filtering, and RPC.
Copy the install command and let the AI configure it · recommended for beginners
No copy-paste install info for "postgrest-mcp" yet — see the docs or source repo.
Connect to my PostgREST service and list all available tables, views, and key columns, grouped by schema.
A schema-organized overview of the database, including tables, views, and key columns.
Query the orders table for paid orders from the last 30 days. Return id, customer_id, total_amount, and created_at, sorted by created_at descending.
A filtered list of matching orders with selected fields, sorted by newest first.
Call the RPC function for monthly sales totals with parameters from January 2024 to March 2024, and return monthly aggregated results.
Monthly aggregated sales results for the specified period, ready for reporting or analysis.
Safely inspect and query PostgreSQL databases using natural language.
Query PostgreSQL, inspect tables, and explore schemas through MCP clients.
Connect to PostgreSQL via MCP for queries, schema inspection, and database changes.
Connect AI assistants to PostgreSQL for secure querying, management, and analysis.
Safely query and inspect PostgreSQL databases without enabling risky write operations by default.
Safely query read-only PostgreSQL data and inspect schemas, tables, and columns.