Download
Grab the latest from Releases:
Started without arguments (or from the apps menu), Rowbase opens the web UI in your browser; starting it again just
reopens the page. A downloaded Linux one-file binary has no "executable" flag, so a double-click does nothing — use the
.deb or the install command above, or chmod +x it. Builds are not code-signed yet:
macOS → System Settings → Privacy & Security → Open Anyway; Windows → More info → Run anyway.
Updates. The Mac app: Rowbase → Check for Updates… (from 0.3.0). One-file binaries: rowbase update, or the
Update button in the web UI. PyPI installs: pipx upgrade rowbase-db. The only request is an anonymous check of
GitHub Releases, at most once a day — no telemetry; turn it off with ROWBASE_NO_UPDATE_CHECK=1.
Connect your AI assistant (MCP)
Open AI / MCP in the app, click Copy prompt, paste it into your assistant — it registers the server, reads the built-in guide and creates a reusable skill. Or register manually:
claude mcp add rowbase -- /path/to/rowbase mcp # one-file binary or app
claude mcp add rowbase -- uvx --from rowbase-db rowbase mcp # straight from PyPI, nothing to download
Listed in the official MCP Registry as io.github.djstreet11/rowbase.
Results come back as compact TOON tables (~40% fewer tokens than JSON):
rows[2]{id,customer,total}:
1,"Smith, Bob",9.50
2,ann,null
truncated: false
Tools: guide, connections, databases, tables, describe, search_schema, sample, count, query, explain, find_ref
(+ apply_changes only when you allow writes). Details: docs/MCP.md.
CLI
Install from PyPI (pipx install rowbase-db / uv tool install rowbase-db) or use a one-file download.
rowbase add shop 'postgres://[email protected]/shop?ssh=deploy@bastion' # read-only unless --rw
rowbase tables -c shop
rowbase q "SELECT * FROM orders WHERE status = 'new'" -c shop --format json
rowbase ui # web UI on http://127.0.0.1:8765
rowbase mcp # MCP server (stdio)
rowbase doctor # environment report
rowbase update # update a one-file binary in place (--check: only check)
Build from source
- Python track:
python3 -m venv .venv && .venv/bin/pip install -e . && .venv/bin/rowbase ui - One-file binaries: docs/BUILDING.md · Native macOS app:
cd native && swift build· releases: docs/RELEASING.md - Architecture & roadmap: SPEC.md
Contributing
Issues, ideas and pull requests are welcome — see CONTRIBUTING.md and the Code of Conduct. If Rowbase is useful to you, a ⭐ helps others find it.
License
Apache-2.0 — see NOTICE and THIRD_PARTY_LICENSES.md.