Awesome GitHub RepositoriesSyntax Validation

sqlglot is a SQL parser and transpiler that represents queries as abstract syntax trees to enable structural analysis, modification, and semantic transformation. It functions as a dialect translator and query optimizer, converting SQL code between different database engines and simplifying syntax trees through rule-based normalization. The project provides a framework for defining custom SQL dialects by overriding tokenizers, parsers, and generators. It includes a lineage analyzer to track data flow from source tables through complex queries to identify the origin of specific columns. Additi

Yearning is a MySQL SQL audit platform and database change management system. It provides a governance framework for reviewing, approving, and auditing SQL statements executed against MySQL databases. The platform features an AI-powered SQL optimizer that suggests performance improvements and converts natural language requests into executable SQL code. It manages database changes through an approval-based workflow engine that includes automated rollback generation and rule-based syntax validation. The system covers role-based access control, security compliance with multi-factor authenticati

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

Standard README هو معيار ومواصفات توثيق markdown مصممة لتنظيم بيانات التعريف والتعليمات الخاصة بالمشروع. يعمل كإطار عمل لحوكمة المصادر المفتوحة يضع مجموعة رسمية من القواعد والقوالب لضمان بقاء معلومات المشروع قابلة للتنبؤ ومتسقة عبر المستودعات المختلفة. يوفر المشروع مدققاً لامتثال التوثيق للتحقق مما إذا كان ملف README يمتثل لمعايير التنسيق المحددة مسبقاً. ويتضمن أدوات لإنشاء قوالب README لإنتاج ملفات توثيق أساسية ونظاماً للإشارة إلى امتثال المواصفات من خلال استخدام الشارات المرئية.

JSqlParser هي مكتبة Java لتحليل استعلامات SQL، تحول سلاسل SQL الخام إلى هيكل منظم من كائنات Java ذات النوع القوي. توفر الوسائل لتحليل ومعالجة استعلامات قاعدة البيانات برمجياً من خلال تمثيلها كشجرة من الكائنات. تدعم المكتبة كلاً من تحليل نص SQL الموجود والإنشاء البرمجي للبيانات الجديدة من خلال واجهة برمجة تطبيقات سلسة. وتتضمن آليات لتحويل أشجار الاستعلام وتسلسل نماذج الكائنات المنظمة مرة أخرى إلى نص SQL منسق. تشمل القدرات الإضافية تحليل مخطط قاعدة البيانات، مثل استخراج أسماء الجداول لتعيين تبعيات البيانات، والتحقق من صحة بناء جملة SQL. المحلل قابل للتكوين للتعامل مع لهجات بناء جملة مختلفة ويتضمن استرداداً متسامحاً مع الأخطاء لمواصلة معالجة النصوص البرمجية بعد مواجهة رموز غير صالحة.

Cortex is an open-source, horizontally scalable metrics platform that ingests, stores, and queries Prometheus-compatible time-series data with multi-tenant isolation. It accepts metrics via Prometheus remote write and OpenTelemetry, executes PromQL queries against both recent and historical data, and provides a Prometheus-compatible alerting and recording rule engine with an integrated Alertmanager. The system is built as a set of independently scalable microservices that use hash-ring-based sharding, gossip-based cluster membership, and tenant-aware object storage to distribute workloads acro

ptpython هو REPL تفاعلي محسّن لـ Python ووحدة تحكم غير متزامنة مبنية على مكتبة prompt-toolkit. يوفر واجهة سطر أوامر قابلة للتخصيص لتنفيذ كود Python مع دعم للتحرير متعدد الأسطر، والإكمال التلقائي، وتمييز بناء الجملة. تدعم البيئة بيانات await على المستوى الأعلى والتنفيذ غير المتزامن عبر حلقة أحداث مدمجة. تسمح بتخصيص واسع للواجهة، بما في ذلك ربط مفاتيح قابل للتكوين للتنقل بأسلوب Vi أو Emacs وأنظمة ألوان مخصصة. تتضمن الصدفة قدرات للتحقق من صحة بناء الجملة في الوقت الفعلي وتنفيذ أوامر صدفة النظام دون مغادرة الجلسة. يمكن دمجها كـ REPL مضمن داخل تطبيقات أخرى أو استخدامها لتغليف الصدفات الخارجية لتوفير وظائف سحرية إضافية.

Pest is a Rust parsing library and automatic parser generator that transforms formal grammar definitions into functional parsers. It specializes in Parsing Expression Grammar to recognize and structure complex text patterns, providing a system for context-free grammar parsing. The library implements zero-copy tokenization and static grammar compilation to reduce runtime overhead. It supports no-std runtime compatibility, allowing the parser to be compiled for embedded or bare-metal environments where a standard library is unavailable. The project covers a range of parsing capabilities, inclu

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

Shellharden is a shell script hardening tool and linter designed to improve the security and reliability of Bash scripts. It functions as an automated utility that rewrites scripts to follow industry standards for quoting and security practices. The project provides an optimizer and standardizer that replaces unsafe patterns and aliases with safer functional equivalents. It includes a syntax highlighter that uses visual markers and colorization to indicate vulnerabilities and areas where quoting corrections are required. The tool covers a broad range of capabilities including automated safet

This repository serves as the technical documentation source for the .NET ecosystem. It consists of a collection of conceptual guides and technical references written in Markdown, acting as the static site content source for a public documentation portal. The project utilizes a Git-based content management system to handle technical writing through pull requests and automated build pipelines. It distinguishes itself through a specialized infrastructure that aggregates content and samples from multiple repositories and branches into a single unified output. The system covers a broad range of

WPGraphQL is a GraphQL interface for WordPress that transforms a WordPress installation into a headless content source. It functions as a GraphQL schema provider that maps database structures and relational data into a standardized schema, exposing posts, pages, and custom data types through a single flexible endpoint. The project includes an integrated API query builder and schema explorer, allowing for the visual composition of queries and real-time validation of responses. It provides a system for extending the schema with custom fields and relationships to expose specific business data.

Lychee is a command line link checker written in Rust that scans websites and local files to identify broken hyperlinks and invalid email addresses. It functions as an asynchronous link validator and static site auditor designed to ensure content accessibility and quality. The tool features disk-based response caching to accelerate subsequent scans and avoid redundant network requests. It supports token-based API authentication for services like GitHub to bypass rate limits when verifying links on remote repositories. The project covers a range of capabilities including multi-format content

This project is a software engineering playbook providing a collection of standardized guidelines and processes for managing the full software development lifecycle and team operations. It serves as a high-level framework for organizing agile project management, API design, containerized development standards, and markdown documentation workflows. The framework establishes a system for language-agnostic API design to automate client library generation and documentation. It also defines standards for providing uniform contributor environments and toolchains through virtualized containers. The