MCP/Rowsafe Database Guard
Rowsafe Database Guard logo

Rowsafe Database Guard

Continuous point-in-time recovery, backup snapshots, schema inspection, query tuning, and agent safety net for databases.

rag-data•Databases & Storage
GitHub15
License:Apache-2.0
VERIFIED
ByRowsafe@Rowsafe

About this Server

Rowsafe is an open-source database administrator and Model Context Protocol (MCP) safety net for AI agents and developers. It supports PostgreSQL, MySQL, MariaDB, MongoDB, ClickHouse, Redis, and SQLite with automated point-in-time recovery (restore to any second), continuous encrypted backups, weekly restore verification tests, schema introspection, lock/bloat diagnosis, slow query explanations, and automatic restore marks before dangerous migrations.

Real-time Interaction

Direct low-latency RPC protocol communication with structured JSON schemas.

Scoped Sandboxing

Restricted capability bounds to prevent accidental modifications or leakage.

Security & Best Practices

Safe Confirmations: Risky migrations and rewinds require explicit confirmation or verified marks to prevent accidental data loss.
Zero Remote Telemetry: Data stays entirely on your database server with client-side encryption before bucket upload.
User Permission Scoping: AI agents operate strictly within the rights of the connected developer identity.

When to Use (and When Not To)

Best For
  • •Safety net protection before applying database migrations, schema alterations, or batch destructive updates
  • •Point-in-time continuous backups and weekly automatic restore test verification
  • •Diagnosing bloat, connection saturation, stuck locks, and transaction wraparound
Not For / Limitations
  • •High-dimensional vector embedding similarity searches (use Chroma or Qdrant MCP instead)
  • •Document collections and streaming pipelines in MongoDB (use MongoDB MCP instead)
  • •Serverless MotherDuck cloud OLAP analytics (use DuckDB / MotherDuck MCP instead)

Install & Setup

terminal command
$claude mcp add rowsafe -- rowsafe mcp mydatabase --allow-writes

Exposed Tools & Endpoints

7 tools

Functions your AI agent can invoke via this Model Context Protocol server

rowsafe_pulse

Calculates a 0-100 database health score covering bloat, locks, stuck sessions, replication, and connection pools.

rowsafe_mark

Creates an immediate named restore point before risky SQL statements, migrations, or deploys.

rowsafe_rewind

Restores database state to any specific second or restores missing rows from a point in time with full undo.

rowsafe_schema

Outputs a compact schema summary of tables, columns, foreign keys, and index utilization optimized for LLMs.

rowsafe_explain

Analyzes why a query is slow, diagnoses execution bottlenecks, and suggests optimal index definitions.

rowsafe_preview

Pre-checks migration scripts for table rewrites, exclusive lock risks, and safe production execution.

rowsafe_fix

Applies verified non-destructive fixes such as ending stuck sessions, vacuuming bloat, or dropping unused indexes.