Awesome GitHub RepositoriesSQL Converters

ShardingSphere is a distributed SQL database middleware that provides sharding, read-write splitting, and distributed transaction management for relational databases. It functions as a layer that intercepts SQL queries to distribute data across multiple physical database instances for horizontal scaling. The project is distinguished by its ability to operate as either a standalone transparent database proxy or via direct integration as a JDBC driver. It features a SQL dialect translator that parses queries into abstract syntax trees to convert syntax between different database engines, enabli

This project is a UUID generation library providing a standards-compliant implementation of RFC 4122. It serves as a tool for creating and validating universally unique identifiers across multiple versions to ensure global uniqueness and prevent data collisions. The library supports several generation methods, including random-based entropy, timestamp sequencing, and namespace-based hashing. It also includes utilities for identifier validation, parsing, and converting identifiers between hexadecimal string representations and binary byte arrays. A command line utility is included for the man

The AWS Cloud Development Kit is an infrastructure-as-code framework that enables developers to define and provision cloud resources using familiar programming languages. By utilizing construct-based synthesis, it translates high-level, object-oriented code into declarative templates, allowing for the automated management of complex cloud environments through a centralized, code-driven control plane. The framework distinguishes itself through its ability to model infrastructure as a dependency-aware resource graph, ensuring that components are provisioned and updated in the correct order. It

FerretDB is an open-source database emulator and protocol translator that mimics a MongoDB environment to support existing drivers and client tools on a relational backend. It functions as a stateless database proxy that converts binary wire protocol messages into SQL statements, allowing a relational engine to handle document-oriented requests. The project serves as a migration tool for moving applications from MongoDB to PostgreSQL without rewriting queries or changing client drivers. It achieves this by using PostgreSQL as a document store, storing and querying BSON documents through a tra

SQLFluff is a multi-dialect SQL linter, formatter, and style guide enforcer. It functions as a parser and analyzer that converts SQL scripts into structured trees to validate syntax, identify logical components, and enforce consistent capitalization, aliasing, and layout conventions across various database dialects. The system is specifically designed to handle templated SQL, providing the ability to analyze, parse, and lint files containing macros or placeholders. It uses dummy-parameter rendering and source mapping to validate the style and correctness of dynamic code before it is rendered

Soar is a suite of specialized tools designed for analyzing MySQL performance, advising on indexing, and optimizing SQL syntax. It functions as a performance analyzer, index advisor, and query optimizer to identify bottlenecks and suggest structural improvements for faster execution. The project distinguishes itself through a system for rewriting SQL statements into optimized equivalent versions using custom heuristic rules and patterns. It also features a dedicated index advisor that evaluates query patterns and database metadata to recommend the creation of new indexes. Its broader capabil

pgloader is a command-line tool that automates the migration of data and schema from various source databases and file formats into PostgreSQL. It combines schema discovery, parallel data pipelines, and type casting into a single, declarative workflow, using PostgreSQL's COPY protocol for high-throughput bulk loading. The tool distinguishes itself by compiling a dedicated command language into concurrent reader-writer pipelines that handle schema introspection, data transformation, and error-resilient batch processing. It supports migrating entire databases from MySQL, MS SQL, SQLite, and Pos

This is an RFC 4122 UUID package for Go that generates, parses, and validates universally unique identifiers. It provides a library for creating UUIDs that conform to standard formatting rules, along with utilities for inspecting UUID properties such as variant, version, and nil status. The package supports DCE 1.1 Security Extension UUID generation and parsing, and includes byte-level UUID construction by directly manipulating 16-byte arrays with version and variant bits. It validates UUID strings against RFC 4122 formatting rules, including hyphens and hexadecimal characters, and can detect

Esta es una librería de Go para generar y analizar identificadores únicos universales (UUID). Proporciona una forma programática de producir identificadores distintos y validarlos según el estándar de la industria RFC 4122. El proyecto se centra en garantizar la unicidad de los datos en sistemas distribuidos y bases de datos. Incluye herramientas para crear identificadores que siguen especificaciones reconocidas y para convertir estos identificadores entre representaciones de cadena y objetos estructurados. La librería cubre capacidades para la validación de datos, análisis y indexación de datos distribuidos. También proporciona utilidades para el seguimiento del estado de la aplicación, manteniendo identificadores estables para objetos o sesiones.

Este proyecto es una biblioteca de compatibilidad de PHP que proporciona un polyfill para la extensión nativa ctype. Sirve como una capa de portabilidad, implementando funciones centrales del lenguaje faltantes para garantizar un comportamiento consistente en diferentes entornos de servidor y versiones de PHP. La biblioteca se especializa en la validación de tipos de caracteres, recreando el comportamiento de las funciones de extensión nativas utilizando código PHP puro. Utiliza la detección del entorno en tiempo de ejecución para identificar si la extensión nativa falta e inyecta implementaciones de respaldo directamente en el espacio de nombres global para evitar colisiones y mantener la portabilidad del código.

This project is a PHP library designed for parsing, beautifying, and syntax-highlighting SQL queries. It provides a set of utilities to improve the readability of database code, facilitate debugging, and assist in the maintenance of complex query structures. The library distinguishes itself by offering both aesthetic and functional processing capabilities. It can transform raw SQL strings into structured, indented formats for human review, or compress them by removing comments and unnecessary whitespace to optimize them for network transmission and logging. Additionally, it includes a syntax

Typeid is a library for generating, encoding, and validating unique identifiers that combine human-readable prefixes with sortable, type-safe suffixes. By integrating descriptive prefixes with standardized binary-to-string conversion, it provides a structured approach to managing identifiers that remain globally unique and consistent across distributed systems. The project distinguishes itself by utilizing time-ordered bit structures and Crockford Base32 encoding to ensure that identifiers are both chronologically sortable and URL-safe. This format allows for the translation of standard 128-b