18 docs tagged with "mysql"

MySQL schema migrations with Atlas, declarative and versioned. Covers inspection, migration planning, and CI/CD integrations.

Learn how to use CHECK constraints in MySQL to enforce data integrity. This guide covers syntax, examples, and how to manage CHECK constraints with Atlas.

Trace column-level lineage across MySQL tables and views: see how columns are derived, inspect expressions, and map upstream and downstream dependencies.

Connect Atlas to your database using a standard URL format. Examples for PostgreSQL, MySQL, MariaDB, SQLite, SQL Server, ClickHouse, Oracle, Snowflake, Spanner, Databricks, and more.

All common open-source relational database management systems are supported in all versions of Atlas.

Learn how to create and use descending indexes in MySQL to optimize queries with ORDER BY clause, and how to manage them using Atlas.

Detect dropped foreign key constraints in MySQL migrations with Atlas linting, understand the impact of each drop, and prevent accidental ones.

Detect inline REFERENCES clauses in MySQL migrations with Atlas linting, understand the implications of inline foreign keys, and prevent them.

Learn how to create and manage functional indexes in MySQL to optimize query performance using expressions and functions.

Learn how to use generated columns in MySQL with Atlas. Understand the difference between stored and virtual generated columns, their limitations, and how to implement them using Atlas HCL schema.

Manage a MySQL schema with Atlas declarative migrations in HCL: inspect the database, plan the changes, and apply them.

Manage a MySQL schema with Atlas declarative migrations in SQL: inspect the database, plan the changes, and apply them.

Learn how to manage MySQL on AWS RDS using Terraform and Atlas. This guide covers provisioning, schema management, and evolving schemas with Atlas HCL.

Define lookup tables and seed data as code. Atlas computes INSERT, UPDATE, and DELETE statements automatically.

Define MySQL roles, users, and permissions as code. Atlas plans and applies changes automatically - no more manual GRANT/REVOKE drift.

Manage MySQL roles, users, and permissions through versioned migrations. Every security change goes through code review and CI before reaching production.

Create prefix indexes in MySQL to optimize query performance and reduce storage space, with the syntax, examples, and benefits of each.

Prevent accidental column drops in MySQL with Atlas migration linting: see the impact of dropping columns and enforce policies against destructive changes.