All data sources

PostgreSQL

API keypostgres

Read-only PostgreSQL connector for SQL queries, table discovery, and schema inspection.

Provenance

PublisherPostgreSQL

Freshness & coverage

FreshnessFreshness not declared
GeographicNot declared
TemporalNot declared
AuthenticationCredentials required (API key)

Methods (4)

  • query

    read

    Execute a read-only SQL query wrapped in a READ ONLY transaction.

    Required paramssql
  • listTables

    read

    List tables in a schema with column counts.

    Defaults to the public schema when schema is omitted.

  • describeTable

    read

    Describe columns for a table including data types and primary key flags.

    Required paramstable

    Schema defaults to public when not specified.

  • listSchemas

    read

    List non-system schemas available in the database.