Serve (Postgres Wire)

Expose your semantic layer over the PostgreSQL wire protocol for BI tools and clients.

sidemantic serve starts a PostgreSQL-compatible server that rewrites semantic queries into warehouse SQL.

Basic

sidemantic serve ./models --port 5433

uvx sidemantic serve --help

Usage: sidemantic serve

Authentication

sidemantic serve ./models --username admin --password secret

Network Boundaries and TLS

Sidemantic’s server is intended to run:

• locally for development, or
• behind a reverse proxy / tunnel that terminates TLS and controls network access.

Debugging

• Start with --demo to validate connectivity:

  sidemantic serve --demo
  

• If BI tools behave oddly, capture:
  • the semantic query
  • the compiled SQL
  • the client’s connection settings