SQL connectors

FederIQ attaches Postgres, MySQL, and SQLite natively via DuckDB's postgres_scanner, mysql_scanner, and sqlite_scanner extensions — meaning queries push down to the remote engine wherever possible.

Postgres

- name: sales
  type: postgres
  dsn: "host=db.internal port=5432 dbname=sales user=app password=secret"

Reference tables with three-part names:

SELECT * FROM sales.public.orders LIMIT 10;

MySQL

- name: catalog
  type: mysql
  dsn: "host=db.internal port=3306 user=app password=secret database=catalog"

SQLite

- name: analytics
  type: sqlite
  path: "./data/analytics.db"

Read-only by design

FederIQ attaches every SQL source READ_ONLY. Writes go through the source's own tools.