PostgreSQL: Query your databases directly

What it’s for: Application data including sales metrics, user counts, inventory, JSON data, and any PostgreSQL-stored data.

Also works with

TimescaleDB (time-series extension for PostgreSQL)

Good to know

Query language: SQL, including advanced features like common table expressions (CTEs) and window functions
Native JSON and JSONB support for querying semi-structured data
Works with TimescaleDB, the time-series extension for PostgreSQL

Best for

Application dashboards
Data already in PostgreSQL
Semi-structured data (JSON)
Time-series data with TimescaleDB
Combining technical and application metrics

Tip: As a general practice, point dashboard queries at a read replica to protect a busy production database.

Documentation

View the full documentation.

PostgreSQL data source

Read script

Script

PostgreSQL is a feature-rich relational database, and the data source gives you access to its advanced features. CTEs (Common Table Expressions) let you write complex analytical queries that would be painful in plain SQL. Window functions enable running totals, rankings, and moving averages.

Native JSON support means you can query JSONB columns directly, which helps if you’re storing semi-structured data.

And if you’re using TimescaleDB, the time-series extension for PostgreSQL, the data source works with it once you turn on the TimescaleDB option in the data source settings. As with MySQL, a good general practice is to point dashboard queries at a read replica to protect your production database.

PostgreSQL’s capabilities make it excellent for sophisticated application dashboards.

PostgreSQL: Query your databases directly

Also works with

Good to know

Best for

Documentation

Still have questions?

Get every update