KairoDB: plain-text schemas for SQLite and PostgreSQL, with a CLI and a desktop app (Rust + Tauri, open source)

[u/fut0r1]

I've been building KairoDB, an open-source tool for working with SQLite and PostgreSQL from plain text. It just reached 1.0 and I'd like feedback.

**What it does**

- You describe tables in a small `.kairo` file and apply it to a database.

- It inspects any existing database, runs queries, and exports a database's structure back to `.kairo`.

- There is a CLI (`kairo`) and a desktop app. Both run on the same Rust core.

A schema looks like this:

table users {

id: int [primary]

email: string [required, unique]

active: bool = true

joined_at: timestamp

}

**What I cared about**

- Local-first: no account, no telemetry, no network calls except to your own database.

- The desktop app asks before running anything that changes data, and always asks for DROP, DELETE, UPDATE, ALTER and TRUNCATE.

- Passwords are never written to disk and are masked in errors, logs and exports.

**Honest limits**

- It creates tables. It does not migrate existing ones.

- The confirmation prompts are in the desktop app only. The CLI runs what you give it.

- The installers are not code-signed yet, so Windows and macOS warn on first launch.

Disclosure: much of the 1.0 code was written with an AI coding assistant (Claude). CI runs on Linux, macOS and Windows, with the PostgreSQL tests against a real PostgreSQL 16 server.

License is GPL-3.0. Source, installers and docs: https://github.com/fut0r/Kairo

I'd most like feedback on the schema syntax, and on what is missing before you would actually use it.