Rowbase

io.github.djstreet11v0.2.1更新于 Oct 4, 2026

Safe, read-only-by-default MySQL, PostgreSQL & SQLite access for AI agents. TOON output.

已验证STDIO仅桌面Developer ToolsDatabases

概览

AI 生成的概览

默认只读的 MySQL、PostgreSQL 与 SQLite 访问，让助手浏览表结构并执行查询。

功能
Rowbase 是一款数据库客户端，内置 MCP 服务器，提供列出连接、数据库和表，查看表结构、搜索结构、抽样、计数、执行查询以及解释执行计划等工具。结果以紧凑的 TOON 表格格式返回，比 JSON 更省 token。guide 工具会向助手说明用法。只有在明确允许写入时才会出现 apply_changes 工具。
适用场景
当助手需要查看或查询 MySQL、MariaDB、PostgreSQL 或 SQLite 数据库时适用，例如回答数据相关问题、了解陌生的表结构，或编写只读 SQL。也适合希望把数据库客户端与 MCP 服务器合二为一的用户。
运行要求
通过 stdio 在本地运行。可从 PyPI 安装 rowbase-db（例如使用 uvx 或 pipx），或下载 macOS、Linux、Windows 的单文件程序；桌面应用仅支持 macOS。数据库连接需在 Rowbase 中配置，包括 SSH 隧道信息。未声明任何环境变量或请求头。
安装前请注意
连接默认只读，并在多个层面强制执行，但可以开启写入，届时会暴露 apply_changes，助手即可修改数据。连接密码保存在操作系统钥匙串中，而非配置文件。程序尚未代码签名，macOS 和 Windows 首次启动会提示警告。查询结果会发送给你所连接的助手。

安装

在 SourceWeft 中

  1. 打开 控制台中的 Rowbase，将其添加到工作区。
  2. 为需要使用其工具的对话启用该服务。

Desktop only，通过 STDIO。 STDIO 服务会启动本地进程，因此需要 SourceWeft 桌面宿主。

其他 MCP 客户端

参照 仓库 中的启动说明。

README

[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] [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.
  • Nice to use. Foreign-key navigation, "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, cancelEdit rows safely: pending changes, SQL preview, one atomic save

Download

Grab the latest from Releases:

PlatformFileHow to run
macOS (native app)Rowbase-x.y.z.dmgopen, drag to Applications
macOS (one file)rowbase-macos-arm64chmod +x rowbase-macos-arm64 && ./rowbase-macos-arm64
Linux x64 / arm64rowbase-linux-x64 / -arm64chmod +x rowbase-linux-* && ./rowbase-linux-x64 (Ubuntu 20.04+, Debian 10+, RHEL 8+)
Windows 10 / 11rowbase-windows-x64.exedouble-click

Started without arguments, the one-file app opens the web UI in your browser. Builds are not code-signed yet: macOS → System Settings → Privacy & Security → Open Anyway; Windows → More info → Run anyway.

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:

bash
claude mcp add rowbase -- /path/to/rowbase mcp          # one-file binary or appclaude 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,nulltruncated: false

Tools: guide, connections, databases, tables, describe, search_schema, sample, count, query, explain (+ 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.

bash
rowbase add shop 'postgres://[email protected]/shop?ssh=deploy@bastion'   # read-only unless --rwrowbase tables -c shoprowbase q "SELECT * FROM orders WHERE status = 'new'" -c shop --format jsonrowbase ui        # web UI on http://127.0.0.1:8765rowbase mcp       # MCP server (stdio)rowbase doctor    # environment report
Dark mode[Dark 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.

来源：README.md，提交 2a72dc3

工具

0
工具元数据尚未被收录。

版本历史

1
  1. v0.2.1最新Oct 4, 2026