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

Dies ist eine Go-Bibliothek zum Generieren und Parsen von universell eindeutigen Identifikatoren (UUIDs). Sie bietet eine programmatische Möglichkeit, eindeutige IDs zu erstellen und diese gemäß dem Industriestandard RFC 4122 zu validieren. Das Projekt konzentriert sich auf die Sicherstellung der Dateneindeutigkeit in verteilten Systemen und Datenbanken. Es enthält Tools zum Erstellen von Identifikatoren, die anerkannten Spezifikationen entsprechen, sowie zur Konvertierung dieser Identifikatoren zwischen String-Repräsentationen und strukturierten Objekten. Die Bibliothek deckt Funktionen für Datenvalidierung, Parsing und verteilte Datenindizierung ab. Sie bietet zudem Hilfsprogramme für das Application-State-Tracking, um stabile Handles für Objekte oder Sitzungen zu verwalten.

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 ist eine Bibliothek für die Generierung, Kodierung und Validierung eindeutiger Identifikatoren, die menschenlesbare Präfixe mit sortierbaren, typsicheren Suffixen kombinieren. Durch die Integration beschreibender Präfixe mit standardisierter Binär-zu-String-Konvertierung bietet sie einen strukturierten Ansatz für die Verwaltung von Identifikatoren, die über verteilte Systeme hinweg global eindeutig und konsistent bleiben. Das Projekt zeichnet sich durch die Nutzung zeitgeordneter Bit-Strukturen und Crockford-Base32-Kodierung aus, um sicherzustellen, dass Identifikatoren sowohl chronologisch sortierbar als auch URL-sicher sind. Dieses Format ermöglicht die Übersetzung standardmäßiger 128-Bit-Identifikatoren in kompakte, menschenlesbare Strings, was die Interoperabilität zwischen verschiedenen Softwaresystemen und Datenbankschichten erleichtert. Das Toolkit enthält umfassende Validierungsmechanismen zur Durchsetzung strikter Schemaregeln, wie Zeichenbeschränkungen und Präfixanforderungen, die Datenkorruption und Typverwechslungen verhindern. Zusätzlich bietet das Projekt ein Kommandozeilen-Interface, um die Generierung und Dekodierung dieser Identifikatoren innerhalb von Entwicklungs- und Automatisierungsworkflows zu rationalisieren.