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 是一个用于 Node.js 的类型安全 PostgreSQL 客户端，使用标记模板字面量（tagged template literals）来确保参数绑定并防止注入攻击。它提供了一个将应用连接到 PostgreSQL 的框架，并为查询和数据库模式提供自动类型检查。 该项目通过专门的 SQL 查询 Linter 脱颖而出，该 Linter 通过在开发过程中根据实时数据库模式验证代码，来检测无效列和类型不匹配。它还包括一个用于加载大数据集的高性能二进制批量数据插入器（使用原生二进制序列化），以及一个能够在主节点和副本节点之间进行动态查询路由的连接池管理器。 该库涵盖了广泛的数据库能力，包括原子事务管理、动态 SQL 查询构建，以及通过异步迭代流处理大数据集。它进一步提供了用于日志记录和基准测试的中间件拦截器、自定义类型解析，以及用于刷新数据库身份验证凭据的异步回调机制。