Skip to main content

Rowbase icon

Rowbase

A fast, good-looking, read-only-by-default database client — for humans and for AI agents.
MySQL / MariaDB · PostgreSQL · SQLite · native macOS app · one-file app for macOS, Linux & Windows · built-in MCP server

Latest release CI License: Apache-2.0 Rowbase MCP server on Glama PyPI MCP Registry

Rowbase: table browser with row inspector

Why Rowbase?

  • Safe by default. Every connection is read-only until you say otherwise — enforced at four independent layers (driver-level single statement, SQL guard, READ ONLY transaction, timeouts). Production connections get a red accent.
  • Made for AI assistants too. A built-in MCP server lets Claude, Cursor, Codex & co. explore your schema and query data — read-only unless you allow writes, with a token-efficient output format (TOON) and a built-in guide so the assistant knows how to use it. One copy-paste prompt sets everything up.
  • One file, no installer. Download a single binary for macOS, Linux or Windows and run it — no admin rights, no Python, no drivers to install. Or use the native macOS app.
  • No SQL required. Filter any column from its header like in DataGrip — pick values from a list with counts, or use contains / starts with / between / LIKE / regex / NULL — and build whole queries visually (joins, counts and sums, conditions, sorting) in the query builder, with the generated SQL shown live.
  • Nice to use. Foreign-key navigation (also for UUID references without FKs, e.g. 1C-style schemas), "referenced by", transpose, column picker, schema-aware autocomplete, EXPLAIN highlighting, query cancel, inline editing with SQL preview, export to CSV/JSON/Markdown/SQL, SSH tunnels.
  • Open source under Apache-2.0. Passwords live in your OS keychain, never in config files.
SQL editor with autocomplete and results Inline editing with pending changes
SQL editor: autocomplete, ⌘↩ runs the statement under the caret, EXPLAIN, cancel Edit rows safely: pending changes, SQL preview, one atomic save

Download

Grab the latest from Releases:

Platform File How to run
macOS (native app) Rowbase-x.y.z.dmg open, drag to Applications
macOS (one file) rowbase-macos-arm64 chmod +x rowbase-macos-arm64 && ./rowbase-macos-arm64
Ubuntu / Debian rowbase_x.y.z_amd64.deb / _arm64.deb double-click → Install (or sudo apt install ./rowbase_*.deb), then start Rowbase from the apps menu
Linux, no root one command curl -fsSL https://raw.githubusercontent.com/djstreet11/Rowbase/main/packaging/install.sh | sh — installs to ~/.local/bin + apps menu
Linux x64 / arm64 (one file) rowbase-linux-x64 / -arm64 chmod +x rowbase-linux-* && ./rowbase-linux-x64 (Ubuntu 20.04+, Debian 10+, RHEL 8+)
Windows 10 / 11 rowbase-windows-x64.exe double-click

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://me@db.example.com/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)
Dark modeDark mode

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.

Metadata

Release files for rowbase-db 0.3.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for rowbase-db 0.3.0
File Size Uploaded Provenance Actions
rowbase_db-0.3.0.tar.gz 109.6 kB With provenance Details for rowbase_db-0.3.0.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for rowbase-db 0.3.0
File Interpreter ABI Platform Actions
rowbase_db-0.3.0-py3-none-any.whl Python 3 none any Details for rowbase_db-0.3.0-py3-none-any.whl

Total release size: 210.4 kB

Release files / rowbase_db-0.3.0.tar.gz

Download URL rowbase_db-0.3.0.tar.gz
Size 109.6 kB
Tags Source
SHA-256 checksum
How to use checksums
18bbca9b7d2811b17191ac04c76d27a8b8f0871871f60a0c8f22f587f876c5ad
BLAKE2b-256 checksum
How to use checksums
3c3d62f4c03dce5fed2718ef8439a76ce88af4d21b874cc22eeb8c9d2620fce4
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.14

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Oct 7, 2026.

Transparency log

Release files / rowbase_db-0.3.0-py3-none-any.whl

Download URL rowbase_db-0.3.0-py3-none-any.whl
Size 100.8 kB
Tags Python 3
SHA-256 checksum
How to use checksums
0da9ef01a85d3fe79f73950d72d99e5c1e412ccff62f3d830625d7656857f7e5
BLAKE2b-256 checksum
How to use checksums
e626354484f344ce759313beee84a093f1fe5492c3350c25006be9cff0ce1bb2
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.14

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Oct 7, 2026.

Transparency log

Security for rowbase-db 0.3.0

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

Full provenance

Both files in this release have been uploaded with provenance metadata.

Select from 2 files

Attestation for rowbase_db-0.3.0.tar.gz

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Oct 7, 2026.

Transparency log

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page