Build interactive data applications with PostgreSQL data

Hex securely and efficiently connects to Postgres to let you build rich analyses and data apps with SQL.

How it works

Once a Hex admin has connected to a PostgreSQL database, it's easy for any user to securely query data with a rich SQL IDE— right from the notebook environment.

Hex is a powerful data platform with first-class SQL support, so you can build powerful analyses and data apps entirely from SQL— or bring in Python and leverage its rich package library, without changing tools or moving data.

postgres Postgres
in-use2 cells
postgres Postgres
select
cast({{timeframe}} as timestamp) as month,
ship, destination,
sum(spice_tons) as spice_tons
from atreides.vehicle_destinations
group by 1,2,3
output-arrow
dataframe

Wire-compatible with Postgres

Materialize
Cube