Atlas is a SQL database schema management tool and database infrastructure as code framework. It provides a declarative database migration engine that computes the difference between a desired schema state and the current database state to automatically generate the necessary SQL for transitions. The project distinguishes itself through a comprehensive suite of analysis and visualization tools, including a database schema linter that detects destructive changes and data loss risks. It also features a SQL schema visualization tool capable of generating entity-relationship diagrams from extract
Bytebase is a database DevSecOps platform and management console designed to orchestrate schema migrations, deployments, and security audits across multiple database engines. It serves as a SQL GitOps tool that synchronizes database states with configurations stored in Git repositories to manage infrastructure as code. The platform distinguishes itself through a multi-database management console that provides a single interface for relational and NoSQL databases. It includes a security layer for role-based access control, database activity auditing, and column-level data masking to protect se
sqlparse is a Python library for the programmatic analysis and manipulation of SQL statements. It provides a non-validating parser that breaks down SQL text into tokens and a utility to divide strings containing multiple queries into individual statements. The project includes a code formatter that reorganizes SQL statements using consistent indentation and keyword casing. It also provides mechanisms for automating this formatting and linting process through version control hooks to maintain code consistency.
This project is a Language Server Protocol implementation for PostgreSQL that provides autocompletion, syntax diagnostics, and type checking for SQL and PL/pgSQL. It functions as a database schema validator and a static analysis engine designed to detect security vulnerabilities, performance bottlenecks, and dangerous migration patterns in database scripts. The server differentiates itself by using live database connections to provide schema-aware intelligence, allowing it to verify that tables, columns, and data types actually exist. It performs static analysis on procedural functions to det
Automatically identify anti-patterns in SQL queries
The main features of jarulraj/sqlcheck are: Data Utilities, Database Design Patterns, SQL Analysis and Linting.
Open-source alternatives to jarulraj/sqlcheck include: ariga/atlas — Atlas is a SQL database schema management tool and database infrastructure as code framework. It provides a… supabase-community/postgres-language-server — This project is a Language Server Protocol implementation for PostgreSQL that provides autocompletion, syntax… andialbrecht/sqlparse — sqlparse is a Python library for the programmatic analysis and manipulation of SQL statements. It provides a… bytebase/bytebase — Bytebase is a database DevSecOps platform and management console designed to orchestrate schema migrations,… dalibo/ldap2pg — :elephant: :busts_in_silhouette: Manage PostgreSQL roles and privileges from YAML or LDAP. ankane/pgsync — Sync data from one Postgres database to another.