Awesome GitHub RepositoriesSQL Schema Validators

sqlc is a code generation tool that compiles raw SQL queries into type-safe application code. By analyzing SQL statements against database schema definitions during the build process, it eliminates the need for manual data mapping and prevents runtime type errors. The project functions as a schema-aware generator that translates database column types into native language primitives. It distinguishes itself through a modular, plugin-based architecture that allows for the extension of the generation pipeline to support diverse programming languages and custom frameworks beyond its default capab

This toolkit provides an asynchronous interface for interacting with relational databases, offering a unified driver-agnostic layer for managing connection pools and executing transactions. It is designed to integrate with asynchronous runtimes, enabling non-blocking database operations while maintaining secure, encrypted communication between the application and the database server. The project distinguishes itself through its compile-time validation capabilities, which use procedural macros to inspect SQL syntax and parameter types against a live database schema during the build process. Th

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

SQLDelight is a Kotlin database library that validates SQL schema, statements, and migrations at compile time, generating type-safe Kotlin query functions from labeled SQL files. It treats SQL as the source of truth for database definitions, catching schema errors during the build process before they reach production. The library supports multiple database dialects including SQLite, MySQL, PostgreSQL, HSQL, and H2, and generates platform-specific code for Android, iOS, JVM, and JavaScript targets. It provides a platform-specific driver abstraction that handles database connectivity difference

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

Slonik es un cliente de PostgreSQL con seguridad de tipos para Node.js que utiliza tagged template literals para asegurar que los parámetros estén vinculados y protegidos contra ataques de inyección. Proporciona un framework para conectar aplicaciones a PostgreSQL con verificación de tipos automática para consultas y esquemas de base de datos. El proyecto se distingue por un linter de consultas SQL especializado que detecta columnas inválidas y discrepancias de tipos verificando el código contra un esquema de base de datos en vivo durante el proceso de desarrollo. También incluye un insertador de datos masivos binario de alto rendimiento para cargar grandes datasets usando serialización binaria nativa y un gestor de pool de conexiones capaz de enrutamiento dinámico de consultas entre nodos primarios y réplicas. La librería cubre un amplio conjunto de capacidades de base de datos, incluyendo gestión de transacciones atómicas, construcción dinámica de consultas SQL y procesamiento de grandes conjuntos de resultados mediante streaming async-iterable. Además, proporciona interceptores de middleware para logging y benchmarking, parseo de tipos personalizado y mecanismos de callback asíncronos para refrescar credenciales de autenticación de base de datos.