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

This is a Go library for generating and parsing universally unique identifiers. It provides a programmatic way to produce distinct identifiers and validate them according to the RFC 4122 industry standard. The project focuses on ensuring data uniqueness across distributed systems and databases. It includes tools for creating identifiers that follow recognized specifications and converting these identifiers between string representations and structured objects. The library covers capabilities for data validation, parsing, and distributed data indexing. It also provides utilities for applicati

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 هي مكتبة لتوليد، وترميز، والتحقق من معرفات فريدة تجمع بين بادئات قابلة للقراءة البشرية ولاحقات قابلة للفرز وآمنة من حيث النوع. من خلال دمج البادئات الوصفية مع تحويل قياسي من ثنائي إلى نص، فإنها توفر نهجاً منظماً لإدارة المعرفات التي تظل فريدة عالمياً ومتسقة عبر الأنظمة الموزعة. يتميز المشروع باستخدام هياكل بت مرتبة زمنياً وترميز Crockford Base32 لضمان أن المعرفات قابلة للفرز زمنياً وآمنة للاستخدام في URL. يسمح هذا التنسيق بترجمة المعرفات القياسية ذات 128 بت إلى سلاسل مدمجة وقابلة للقراءة البشرية، مما يسهل التشغيل البيني بين أنظمة البرمجيات وطبقات قاعدة البيانات المختلفة. تتضمن مجموعة الأدوات آليات تحقق شاملة لفرض قواعد مخطط صارمة، مثل قيود الأحرف ومتطلبات البادئة، والتي تمنع تلف البيانات وخلط الأنواع. بالإضافة إلى ذلك، يوفر المشروع واجهة سطر أوامر لتبسيط توليد وفك تشفير هذه المعرفات داخل تدفقات عمل التطوير والأتمتة.