ariga/atlas

Features

• Database Migrations - Provides a comprehensive system for versioning and applying sequential schema changes via source control.
• Declarative Schema Managers - Implements a declarative engine that computes the difference between desired and current schema states to automate transitions.
• Schema State Diffing - Computes the difference between a desired schema state and the current database state to generate migration plans.
• Infrastructure as Code Frameworks - Provides a framework for managing database roles, permissions, and schemas as version-controlled code.
• SQL Analysis and Linting - Parses and inspects SQL statements to detect destructive operations and policy violations before they are executed.
• Database Schema Linting - Includes a database schema linter that detects destructive changes and data loss risks.
• Multi-Format Definitions - Supports defining database structures using various formats including SQL and HCL to maintain a declarative source of truth.
• Data Schema Management - Provides a software development kit to embed schema management and migration logic directly into applications.
• Database Schema Managers - Provides a toolset for defining, versioning, and managing database structures across environments.
• Destructive Change Detection - Flags schema modifications that would result in data loss, such as dropping columns, to prevent accidental deletion.
• Migration Execution - Executes pending schema migration files against databases to bring them up to the latest version.
• Migration Generation - Automatically generates SQL migration scripts to move a database from its current state to a desired state.
• Schema Extractions - Extracts the current structure of a running database and outputs it as a schema definition file.
• Schema Dependency Analysis - Tracks relationships between database objects to determine the correct execution order for migrations and destructive changes.
• Configuration as Code - Manages database roles, permissions, and row-level security policies as version-controlled code.
• Compliance and Governance - Ensures database governance by enforcing safety checks, naming conventions, and security policies.
• Database Access Controls - Implements database access control as code, managing roles and permissions via declarative configuration files.
• Declarative Migrations - Implements an engine that automatically computes the difference between current and target schema states to apply updates.
• Database Schema Validations - Verifies the semantic and syntactic correctness of schema files against specific database engines before application.
• CI/CD Integrations - Integrates database schema linting and migration testing into automated CI/CD and GitOps pipelines.
• Schema Policy Enforcement - Enforces architectural standards and naming conventions via custom linting rules applied to schema definitions.
• Data-Dependent Change Detection - Warns when schema changes might fail due to existing data, such as adding unique constraints to duplicate values.
• Non-Blocking Index Operations - Modifies generated SQL to use concurrent index creation, preventing table locking and ensuring high availability.
• Declarative Data Seeding - Controls lookup table rows and seed data declaratively by computing minimal diffs.
• Migration Checksum Verification - Maintains a checksum file to verify that migration scripts have not been edited after being created.
• Database Schema Visualizers - Generates entity-relationship diagrams and visual representations of extracted database structures.
• Dynamic SQL Generators - Computes database schemas dynamically by injecting variables into SQL files using templates.
• Migration Integrity Verification - Ensures migration integrity by comparing file hashes against stored records to detect out-of-band edits.
• Migration Registries - Provides a remote registry to host versioned migration files for centralized management and deployment.
• Migration Reversion - Provides utilities to roll back or undo specific schema changes during development.
• Cross-Tenant Schema Execution - Executes schema updates across multiple isolated tenant databases using staged rollout strategies.
• ORM Integrations - Automates the planning and execution of database migrations by integrating with various object-relational mapping libraries.
• Reference Data Population - Synchronizes standardized reference datasets between configuration files and the database using various sync modes.
• Remote Migration Registries - Decouples migration definition from deployment by storing approved execution plans in a centralized remote repository.
• Schema Migration Validation - Validates database schemas and migration scripts using software testing paradigms to ensure correctness.
• Schema-to-Code Exports - Converts existing database schemas into SQL files to enable code-based management and version control.
• Database Schema Explorers - Reads a database's current state and exports the structure into DDL, SQL, or JSON formats.
• Linter Policy Customization - Customizes the severity of individual linting checks to either ignore specific warnings or treat them as hard errors.
• GitOps Deployment Management - Automates the application of database migrations based on the desired state committed to a Git repository.
• Infrastructure as Code - Provides integration with infrastructure as code tools to manage database state as a declarative resource.
• Schema - Monitors live databases to identify and remediate unplanned changes that deviate from the defined source of truth.
• Infrastructure-as-Code Integration - Automates linting, testing, and application of migrations via Kubernetes, Terraform, and CI pipelines.
• Remote Application Hosting - Hosts migration files in a remote environment to facilitate centralized deployment across different clusters.
• Identity and Role Management - Defines database users and roles with support for inheritance and secure password injection.
• Migration Policy Evaluators - Evaluates custom allow or deny logic against planned migrations to block deployments that violate organizational standards.
• Row-Level Security - Defines security policies that restrict data access by filtering individual rows based on user roles.
• SQL Firewalls - Inspects and filters SQL queries using regular expressions to block dangerous or unauthorized database operations.
• SQL Injection Detection Tools - Analyzes SQL statements for unsafe dynamic patterns and string concatenation to detect potential injection vulnerabilities.
• Database Breaking Change Detection - Identifies backward-incompatible schema changes that could disrupt applications relying on older versions.
• Diff Logic Customization - Customizes the diff engine to handle specific database operations, such as concurrent index creation.
• Template-Based Schema Generation - Injects variables into SQL definitions at runtime to generate environment-specific schemas from a single source.
• Database - Validates that database tables, columns, and indexes follow organizational naming patterns for consistency.
• Schema Registries - Stores and tracks a single source of truth for schema migration plans in a centralized registry.
• Transactional Migration Managers - Provides the ability to execute schema migrations within atomic transactions to ensure database integrity.
• Workflow Approval Gates - Implements approval gates that require manual verification before migration plans can be deployed to the database.
• Lookup Table Synchronization - Synchronizes row data in lookup tables by generating SQL to match a desired state.
• Database Tools - Listed in the “Database Tools” section of the Awesome Go awesome list.
• Schema Migration Tools - Database toolkit for managing data and schema.
• Schema Migration Tools - Tool to inspect and apply database schema changes.
• Command Line Tools - Tool for managing and migrating schemas using DevOps principles.

Star history