Loading...

PostgreSQL

Run read-only SQL queries against your PostgreSQL database and bring the results into the sheet.

The PostgreSQL connector runs a SQL query of your choice, read-only, against a PostgreSQL database (including a managed service like Neon or Supabase): no OAuth required, it uses the host, port, database name, username and password you enter when connecting.

Only SELECT queries are allowed (optionally preceded by WITH): no INSERT, UPDATE, DELETE or statements that change the schema, checked before every run.

Tip for daily updates: just like MySQL, to pull only new data every day (with a schedule and "Append new results to old" enabled), write a condition using PostgreSQL's own date functions directly in the query, e.g. WHERE data_inserimento = CURRENT_DATE or WHERE data_inserimento >= CURRENT_DATE - INTERVAL 1 DAY.

Available metrics

There are no fixed metrics or dimensions: the report columns are exactly the columns your SQL query returns.

Known limits

  • SELECT-only queries (or WITH)
    One statement per query, no INSERT/UPDATE/DELETE or schema changes: checked before every run.
  • No test when you connect
    The connection page saves what you enter without testing it: the real test happens the first time you select that connection to configure a report.
  • SSL handled automatically
    The connection uses the driver's default behavior (SSL if the server requires it, like Neon/Supabase, otherwise plain): nothing to configure.
  • The server must be reachable from the internet
    Does not work with local networks or behind a VPN. On a self-managed server (not a service like Neon/Supabase) the firewall must allow Google's IPs (gstatic.com/ipranges/goog.json), and the port must be 1025 or higher (standard 5432 is fine).

Filters and sorting

  • The sidebar's filters, sorting and limit don't apply
    Same as MySQL: the SQL query decides everything. Write WHERE, ORDER BY and LIMIT directly in the query.