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]

Default Schema (search_path)

The optional Default Schema setting in the connection form sets PostgreSQL’s search_path for unqualified table names. Enter one schema, or a comma-separated list to define a search order. The first schema is the effective default; later schemas are fallbacks. For example, app, public searches app before public.

When the first configured schema is an unquoted schema name and is available, the sidebar focuses it after the schema list loads. Leave the setting empty to use the server’s default search_path.

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