Sign up
All data sources

PostgreSQL

Your key

Read-only access to your PostgreSQL databases, with schema inspection and SQL queries.

Set up this sourceGet the full contract and schemas as JSONConnect this source →

Needs your own PostgreSQL key. Included on Free.

What you can ask

  • “What does PostgreSQL have for the area or asset I'm working on?”
  • “Pull the most recent PostgreSQL records and put them in a table.”
  • “What does PostgreSQL cover, and how fresh is the data?”

About this source

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

Connector ID postgres

Provenance

PublisherPostgreSQL

Freshness & coverage

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

› Methods (4)

Technical detail for developers: parameters, pagination, units, and freshness per method.

  • query

    read

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

    Required paramssql
    Entitiesquery

  • listTables

    read

    List tables in a schema with column counts.

    Entitiestable

    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
    Entitiestable, column

    Schema defaults to public; table may be qualified as schema.table.

  • listSchemas

    read

    List non-system schemas available in the database.

    Entitiesschema