PostgreSQL

data-peek is optimized for PostgreSQL with full feature support.

Supported Versions

• PostgreSQL 12+
• Compatible with cloud providers: Supabase, Neon, Railway, AWS RDS, etc.

Connection

postgresql://[user]:[password]@[host]:[port]/[database]?sslmode=[mode]

SSL Modes

Supported Data Types

Numeric

• smallint, integer, bigint
• serial, bigserial, smallserial
• numeric(p,s), decimal(p,s)
• real, double precision
• money

Character

• char(n), varchar(n), text
• bytea

Date/Time

• timestamp, timestamptz
• date, time, timetz
• interval

Boolean & UUID

• boolean
• uuid

JSON

• json, jsonb

Arrays

• All types support array notation (e.g., integer[], text[])

Network

• cidr, inet, macaddr

Geometric

• point, line, box, path, polygon, circle

Range Types

• int4range, int8range, numrange
• tsrange, tstzrange, daterange

PostgreSQL-Specific Features

EXPLAIN ANALYZE

Full support for query plan visualization with actual execution statistics.

Sequences

View and use sequences for auto-increment columns.

Custom Types

Full support for:

• Enums (with value dropdowns in editor)
• Composite types
• Domains

Table Designer

All PostgreSQL features in table designer:

• All index methods (btree, hash, gist, gin, spgist, brin)
• Partial indexes
• Covering indexes (INCLUDE)
• Check constraints
• Exclusion constraints
• Inheritance
• Partitioning

Functions

Use PostgreSQL functions in queries:

• now(), current_timestamp
• gen_random_uuid()
• array_agg(), json_agg()
• All standard functions