postgres

What it does

• Runs read-only SQL against the Postgres URI you configure.
• Returns rows, column metadata, and execution time.
• Schema introspection is automatic; you do not have to describe tables.

API spec

{
  "name": "postgres",
  "input_schema": {
    "properties": {
      "query": { "type": "string" },
      "params": { "type": "array" },
      "max_rows": { "type": "integer", "default": 1000 }
    },
    "required": ["query"]
  }
}

Security

Read-only by default — INSERT/UPDATE/DELETE rejected unless you opt in. Connections via your URI; we never store credentials in plaintext.

Used by

Gotchas

• EXPLAIN before queries on tables >100M rows; missing indexes will time out.
• 1000-row default cap; pass max_rows for larger pulls (cost increases).