Lets AI agents explore database schemas and query data from MySQL, PostgreSQL, and SQLite using a safe, read-only-by-default connection.
Also known as djstreet11/Rowbase, rowbase-db
- Stars
- 1
- Tools
- —
- Downloads, 30 days
- 232
- Latest version
- 0.3.0
- Last commit
- Oct 7, 2026
- License
- Apache-2.0
What is Rowbase MCP?
Rowbase lets AI agents explore database schemas and query data from MySQL, PostgreSQL, and SQLite using a safe, read-only-by-default connection.
Summary generated from the project's README
About Rowbase MCP server
Rowbase provides a secure way for AI agents to interact with various database systems including MySQL, MariaDB, PostgreSQL, and SQLite. It functions as a built-in MCP server that allows assistants like Claude or Cursor to explore schemas and run queries. The connection is read-only by default, utilizing four independent layers of protection to ensure production data remains safe unless you explicitly permit write operations.
Developers can set up the server by copying a prompt from the application or using command line registration via uvx or the local binary path. The server uses a specialized TOON output format to reduce token usage by approximately 40% compared to standard JSON. It includes specific tools such as describe, search_schema, sample, count, query, explain, and find_ref to help agents navigate complex data structures efficiently.
What you can do with it
- 1Analyze query performanceAn AI can use the explain tool to help you understand how a SQL statement will execute.
- 2Perform safe data updatesIf you grant permission, an agent can modify records using the apply_changes tool.
Written from the project's README. Every use case is checked against a quote from it.
How to install Rowbase MCP
Formats verified 10 Nov 2026Add to CursorAdd to GooseInstall Rowbase MCP in Claude Code
$ claude mcp add rowbase -- uvx rowbase-dbInstall Rowbase MCP in Cursor
~/.cursor/mcp.json
{
"mcpServers": {
"rowbase": {
"command": "uvx",
"args": [
"rowbase-db"
]
}
}
}Install Rowbase MCP in VS Code
.vscode/mcp.json
{
"servers": {
"rowbase": {
"type": "stdio",
"command": "uvx",
"args": [
"rowbase-db"
]
}
}
}Install Rowbase MCP in VS Code CLI
$ code --add-mcp '{"name":"rowbase","type":"stdio","command":"uvx","args":["rowbase-db"]}'Install Rowbase MCP in Claude Desktop
claude_desktop_config.json
{
"mcpServers": {
"rowbase": {
"command": "uvx",
"args": [
"rowbase-db"
]
}
}
}Install Rowbase MCP in Codex
$ codex mcp add rowbase -- uvx rowbase-dbInstall Rowbase MCP in Codex config.toml
~/.codex/config.toml
[mcp_servers.rowbase] command = "uvx" args = ["rowbase-db"]
Install Rowbase MCP in Gemini CLI
$ gemini mcp add -s user rowbase uvx -- rowbase-dbInstall Rowbase MCP in Gemini settings.json
~/.gemini/settings.json
{
"mcpServers": {
"rowbase": {
"command": "uvx",
"args": [
"rowbase-db"
]
}
}
}Automated checks
Ran Nov 15, 2026Full report →Passed our automated checks. That is not a security audit: read the code and give the server the narrowest access it needs. How checks work
- Source repository linked and reachabledjstreet11/rowbase is public and reachablegithub.com/djstreet11/rowbase ↗Pass
- Package names this repository as its sourcerowbase-db names djstreet11/rowbase as sourcepypi.org/project/rowbase-db/ ↗Pass
- Build provenance (Sigstore attestation)Sigstore attestation for rowbase-dbpypi.org/project/rowbase-db/ ↗Pass
- Open source license (OSI)Apache-2.0spdx.org/licenses/Apache-2.0.html ↗Pass
- Commit or release in the last yearLast commit or release 2026-10-07github.com/djstreet11/rowbase ↗Pass
- OpenSSF ScorecardNot checked
- Package name not close to a popular packageNo popular package one edit away from rowbase-dbPass
- No critical advisory in the package or its dependencies17 resolved dependencies checked; no critical advisoryosv.dev ↗Pass
- No hidden instructions to the model0 tool descriptions and the README read; no override phrases, credential paths or hidden charactersPass
- Destructive tools are labelledNot checked
- Remote endpoint answers the MCP handshakeNot checked
README
View on GitHubWhy 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 ONLYtransaction, 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: 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)
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.
Rowbase MCP questions
How do I add Rowbase MCP to Claude Code?
Run claude mcp add rowbase -- uvx rowbase-db in your terminal. Add --scope user to make it available in every project.
How do I add Rowbase MCP to Cursor?
Open ~/.cursor/mcp.json and add the server under mcpServers, using the Cursor config shown in the install section above.
Is the database connection safe for AI agents?
Yes, every connection is read-only by default and is enforced at four independent layers including a SQL guard and read-only transactions.
Does Rowbase require any installation or drivers?
No, you can download a single binary for macOS, Linux, or Windows that runs without admin rights, Python, or additional drivers.