Skip to content

Repository files navigation

Dialog SQL

Conversational SQL engine. DuckDB federates Postgres; SQLGlot compiles NL→SQL; OPA enforces row filters. This repo uses Poetry + Makefile. Keep commits small.

Dev

  • make dev-up # start services
  • make dev-down
  • make test
  • make dbt-run # build dbt views (optional)

API

  • GET /health
  • GET /schemas
  • POST /query # body: {"question": "...", "materialize_as": "optional_name"}

Notes

  • Set X-User header for RLS.
  • If dbt is enabled, models go to analytics/dbt/models/generated/.

About

Dialog SQL is a production-leaning conversational analytics engine. It turns plain English into safe SQL with SQLGlot, federates queries across DuckDB + Postgres, enforces row-level security via OPA, and optionally streams results over Arrow Flight. Each query can be materialized into dbt models for lineage and governance.

Resources

Code of conduct

Contributing

Security policy

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors

Languages