WHAT IT DOES

What does it do?

Define a database instance, table name, and columns to create a model, then query, insert, and update records with explicit operations. The synchronization CLI generates SQL differences from model definitions and lets users preview schema changes before applying them.

KEY FEATURES

Key features

• Supports MariaDB, MySQL, and SQLite
• Uses Python type definitions and native SQL
• Automatically generates SQL schema differences from model definitions
• Previews and applies schema changes
• Explicitly queries, inserts, and updates records
• Automatically infers primary keys