kasfulk/nook

Database administration for SQLite, PostgreSQL and MySQL — a native egui workbench, a CLI and an MCP server, one Rust codebase

About nook

Database administration for SQLite, PostgreSQL and MySQL — native, fast, and drivable by agents.

A Navicat-style workbench in one Rust codebase: a desktop app (nook), a CLI (nook-cli), and an MCP server for agents. Connections, browsing, data grid, SQL editor, design tools, transfer, sync, backup, scheduler, monitor, privileges, reports, ER diagrams, and test-data generation — every action is a registered command shared by all three surfaces.

Area What you get ------ Connections SQLite files, PostgreSQL, MySQL/MariaDB; SSH tunnel through the system ssh; SSL modes (disable/prefer/require/verify-ca/verify-full); read-only profiles; passwords in the macOS login keychain; connection groups; saved profiles in JSON Browse Catalog read in one pass: schemas, tables, views, columns, types, defaults, comments, indexes, foreign keys, row estimates and sizes Data grid Paging, sort by any column, WHERE filter, inline cell editing with type coercion, insert/duplicate/delete/NULL, a pending-changes list showing the exact statements, one-transaction apply with rollback on first failure Query editor Multi-statement scripts, run statement at cursor, formatter, completion from the live catalog, EXPLAIN/EXPLAIN ANALYZE, history, snippets, transactions AI Natural-language prompt to SQL across 7 providers — OpenAI, Anthropic, DeepSeek, Kimi, GLM, Ollama, vLLM — each with its own base URL; @table in the prompt expands to that table's columns, keys and indexes; API keys in the login keychain, never in the profile file Design Create, copy, rename, drop tables; add/drop/rename/retype columns; null

From the project README.

Maintaining this server?

Add the radar badge to your README — it shows your project was picked up by MCP Radar and links to this page:

[![On MCP Radar](https://mcp.liqiwa.com/badge.svg)](https://mcp.liqiwa.com/s/kasfulk--nook.html)

Related MCP servers