How to use MySQL Compatibility in RepoDB

Unlocking MySQL Power

RepoDB now supports MySQL dialect! This means you can use the familiar MySQL syntax while still enjoying the serverless, multi-tenant benefits of RepoDB. Whether you're migrating an existing app or starting fresh with tools that expect MySQL, we've got you covered.

1. Enabling MySQL Dialect

When creating a new database in the dashboard, simply check the "MySQL Compatibility" box. This tells RepoDB to interpret your queries using the MySQL dialect.

2. Using the SDK

Update your client to specify the dialect. This ensures the client-side parsing and error handling match MySQL's behavior.

const db = new Repodb({
    host: 'https://repodb.ogensync.com',
    token: 'your-token',
    dialect: 'mysql' // Set this to 'mysql'
});

3. Supported Syntax

You can now use MySQL-specific features like LIMIT/OFFSET (already in SQLite), but more importantly, backtick quoting, MySQL-style comments, and common MySQL functions. This makes RepoDB a drop-in replacement for many lightweight MySQL use cases.