PostgreSQL Protocol Guide
Native pgwire protocol, ANSI SQL execution, and PostgreSQL tool compatibility.
Last Updated: August 2026
PostgreSQL Compatibility Overview
KOLMOS exposes a native PostgreSQL wire listener (port 5432) powered by `pgwire` and `datafusion-postgres`. It supports cleartext password authentication and full ANSI SQL query execution.
Sample PostgreSQL Queries
sqlKOLMOS Reference
-- 1. Connect via psql
psql "postgres://postgres:my-secret-password@127.0.0.1:5432/main"
-- 2. Querying with Postgres Dialect
SELECT
id,
name,
COALESCE(email, 'N/A') AS contact_email,
created_at::DATE AS signup_date
FROM users
WHERE status = 'active'
ORDER BY created_at DESC
LIMIT 50;