mori

Mori is an innovative transparent database proxy designed to enhance database interactions by reading from a production database while expertly managing write operations locally. It utilizes copy-on-write semantics to ensure that users can perform operations without affecting the production environment, allowing for seamless resets and recovery.

Key Features

• Unified Access: Mori operates between your application and a production database, intercepting every query. Writes are directed to a local Shadow database, while reads fetch data from production, integrating both sets of information for a cohesive database view.
• Write Protection: Ensures that the production database remains protected from direct writes, eliminating the risk of accidental modifications.
• Instant Reset: Users have the flexibility to break and reset their state without impacting production, offering a safe environment for experimentation and development.

Supported Database Engines

Mori supports various database engines, including:

• PostgreSQL
• CockroachDB
• MySQL
• MariaDB
• MS SQL Server
• SQLite
• DuckDB
• Redis
• Firestore
  Each engine has tailored support for Docker containers or local setups, optimizing integration and performance.

Authentication Providers

Mori facilitates connections across multiple cloud service platforms, such as GCP Cloud SQL, AWS RDS, and MongoDB Atlas, with IAM-based providers handling token refresh automatically to streamline secure access at connection time.

How It Works

Mori classifies every incoming query to determine the best routing strategy, employing various classifications such as READ, WRITE, DDL, and TRANSACTION. The routing logic ensures that:

• Queries without local changes pass through to production directly,
• Merged reads handle local changes by querying both backends and filtering production results,
• Deletes are managed in the Shadow database, ensuring that they are not retrieved in future reads.

Mori enhances efficiency by staging transactions per connection and per transaction, ensuring consistency across production reads and Shadow writes.

Real-Time Monitoring and Management

Utilizing a built-in terminal dashboard, users can monitor connections, query routing, delta counts, schema divergence, and performance metrics in real-time, making it easier to track the state of operations.

Tunneling Capabilities

Mori provides additional functionalities by supporting SSH tunnels and cloud proxy services, allowing connections to databases that are behind private networks and enhancing accessibility for various applications.

For AI Integration

Mori includes built-in support for AI agents via its Model Context Protocol (MCP) server, allowing agents to read from production, write to Shadow, and verify their operations without risking production integrity.

Getting Started

Mori is easy to set up and can be initialized with a few commands. Once configured, it provides a straightforward method for applications to connect to the database proxy, facilitating smooth development workflows without the pitfalls of directly interacting with production data.

For more detailed information on commands, usage, and features, please refer to the README.

Mori redefines database proxies, making it an essential tool for developers and organizations seeking to optimize their database management while ensuring the safety and security of their production environments.