SQL Guide

VaireDB speaks the PostgreSQL wire protocol, so you interact with it using standard SQL through any PostgreSQL client. SQL submitted to the coordinator is parsed by DataFusion, translated to DuckDB's dialect, and dispatched to the core nodes that own the relevant shards.

• Connecting

  Connect with psql and other PostgreSQL clients.

• Tables & Schema

  CREATE TABLE with sharding, ALTER TABLE, DROP TABLE, and catalog introspection.

• Querying Data

  INSERT and SELECT against sharded tables.

• Column Pseudonymization

  Declare columns to be HMAC-SHA256 hashed in the coordinator for compliance.

• Worked Example

  An end-to-end session from empty cluster to query results.

Dialect

Table DDL accepts a WITH (...) clause for sharding options (shards, replication_factor, shard_by). Statement-level SQL is PostgreSQL-compatible and translated to DuckDB internally.