Open-source alternatives to Sqlparse

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

This project is a comprehensive, curated directory of static analysis, linting, and security scanning utilities. It serves as a central resource for developers to discover, compare, and select tools based on specific programming languages, licensing models, and integration requirements. The directory distinguishes itself by providing deep metadata for each listed utility, including community-driven popularity rankings, maintenance status, and deployment methods. By aggregating these tools into a single searchable index, it enables teams to identify solutions for enforcing coding standards, ma

JSqlParser is a Java library for SQL query parsing, converting raw SQL strings into a structured hierarchy of strongly typed Java objects. It provides the means to programmatically analyze and manipulate database queries by representing them as a tree of objects. The library supports both the parsing of existing SQL text and the programmatic generation of new statements through a fluent API. It includes mechanisms for transforming query trees and serializing structured object models back into formatted SQL text. Additional capabilities include database schema analysis, such as the extraction

LearnPython is a programming tutorial consisting of a collection of practical code examples used to demonstrate Python language features and programming patterns. It serves as a comprehensive learning resource that implements core language concepts through functional code. The project provides specialized guides and samples covering several key domains. These include asynchronous network programming with event loops and coroutines, data visualization using numerical datasets for 2D and 3D plots, and web scraping for fetching content and automating login flows. It also features instructions on

PhoneNumberKit is a Swift framework for parsing, formatting, and validating international phone numbers according to global numbering standards. It provides a system of lookup tables, structural parsers, and validation tools to handle the complexities of international telephone numbering. The library converts raw strings into structured objects containing country codes and national numbers. It translates international dialing codes into full country names and verifies whether phone number strings are logically possible and conform to specific regional numbering plans. The project includes ut

go-humanize is a Go library for converting raw numbers, byte sizes, and durations into natural language strings to improve human readability. The project provides specialized formatters for byte sizes using SI or IEC standards and a relative time formatter that transforms durations into descriptions such as three days ago. It also includes an SI unit formatter for converting numeric values to and from International System of Units prefixes and symbols. Beyond technical units, the library includes English natural language utilities for pluralizing nouns, generating ordinal numbers, and joinin

MiniOB is an open-source educational relational database kernel designed for learning the internals of database systems. It implements a dual-engine storage architecture combining B+ Tree and LSM-Tree, supports SQL parsing and query execution, and provides transactional processing with multi-version concurrency control. The system communicates with clients using the MySQL wire protocol and includes a vector database extension for storing and querying high-dimensional vectors. The project distinguishes itself through its comprehensive coverage of core database concepts in a single, learnable c

Rockstar is an esoteric programming language whose syntax is inspired by 1980s hard rock and heavy metal lyrics, making programs read like song lyrics. It uses poetic number literals, where the length of each word in a phrase is parsed as a decimal digit to initialize numeric variables, and pronoun-based variable references, where words like "it" and "they" resolve to the most recently assigned or compared variable at runtime. The language can be compiled to WebAssembly and run inside a web page for in-browser code execution. The language distinguishes itself through a lyric-driven parsing sy

Cleave.js is a JavaScript library that applies real-time visual formatting to form fields as users type. It provides specialized utilities to enforce visual patterns for credit cards, phone numbers, dates, times, and large numerals. The library includes predefined formatting rules for common data types, such as detecting credit card issuers to apply correct spacing and managing country-specific regional patterns for international phone numbers. It also supports large numeral grouping using Western, Indian, and Chinese numbering systems. Users can define custom input patterns using specific b

indent-blankline.nvim is a visual utility for Neovim that improves document readability by rendering vertical alignment lines. This plugin serves as an indentation guide tool designed to clarify the structure of nested code blocks. The plugin utilizes Tree-Sitter parsing to function as a scope highlighter, drawing visual boundaries around variable and function scopes. This allows for the visualization of identifiers and block boundaries based on the language's syntax tree. The system manages code structure visualization through indentation guides and scope-based highlighting. It uses virtual

path-to-regexp is an HTTP route matcher and regular expression generator that transforms parameterized path strings into regular expressions for matching web addresses. It functions as a URL route parser and pattern compiler, enabling the conversion of human-readable path templates into functional expressions for routing. The project provides capabilities for extracting named parameters and wildcards from URLs based on defined path patterns. It also handles the reverse process of dynamic path generation, transforming key-value pairs into formatted path strings by injecting values into defined

JSON5 is a parser and serializer for a human-readable configuration format that extends JSON. It serves as a JavaScript-based data parser that allows for a more flexible version of the JSON specification to simplify manual editing of data files. The project provides capabilities to support comments, trailing commas, and multi-line strings. It includes utilities to convert this extended syntax into standard JSON for compatibility with tools requiring strict specifications. The library covers data serialization, string parsing, and structural syntax validation. It also provides integration for

Collision is a command-line interface error report formatter and developer debugging tool. It functions as a terminal UI component that converts raw application crash logs into stylized, readable error messages. The tool focuses on application crash diagnostics and command-line error reporting to improve the developer experience. It transforms technical error reports and stack traces into a clean, human-readable format to simplify the process of identifying and fixing software bugs. The project achieves this by intercepting standard error streams and using pattern-matching to parse raw log s

Universal Ctags is a multi-language symbol indexer and regex-based parsing engine used to extract and catalog functions, classes, and variables from source code. It functions as a source code indexer that scans files across diverse programming languages to create searchable catalogs of definitions and declarations. The project is distinguished by its extensible parser framework, which allows users to define new language rules using regular expressions and configuration files. It supports complex parsing scenarios through state-based parsing, stack-oriented scope tracking, and guest-parser del

wxParse is a rich text parser and renderer specifically designed for the WeChat Mini Program ecosystem. It transforms standard HTML tags and Markdown syntax into native visual elements and compatible layouts. The system processes structured text strings into a repeating list of visual components and media links. It handles the conversion of complex text formats into formatted media and hyperlinks to ensure content displays correctly across mobile devices. The project manages content through regular expression-based parsing and schema-driven element mapping, translating identified content typ

node-ytdl-core is a JavaScript library for Node.js designed to extract metadata and stream video and audio content from YouTube. It serves as a media downloader and stream fetcher, allowing users to retrieve video details and media data from remote sources. The library provides specialized capabilities for video extraction, including the ability to parse media URLs for unique identifiers and analyze available formats. It allows for the selection and filtering of specific video and audio streams based on quality and resolution criteria. The project manages network traffic through rate limit a

Natural is a natural language processing library for Node.js that provides tools for text analysis, tokenization, and phonetic matching. It functions as a collection of specialized toolsets for word stemming, string similarity quantification, and pattern-based text classification. The library includes a phonetic sound analyzer that converts words into phonetic representations to identify matches based on sound rather than literal spelling. It also features a text classification engine that assigns categories to text inputs using trained models and pattern recognition. Additional capabilities

apidoc is a source-code API documentation generator that parses specialized annotations within comments to automatically create a searchable API documentation website. It functions as an annotation-based API parser and a static documentation site generator, extracting definitions directly from the codebase to maintain a synchronized reference. The tool is designed as a multi-language parser, using configurable regular expressions to extract metadata from various programming languages. It can also serve as a JSON API definition exporter, converting source-code comments into raw JSON files for

Atlas is a SQL database schema management tool and database infrastructure as code framework. It provides a declarative database migration engine that computes the difference between a desired schema state and the current database state to automatically generate the necessary SQL for transitions. The project distinguishes itself through a comprehensive suite of analysis and visualization tools, including a database schema linter that detects destructive changes and data loss risks. It also features a SQL schema visualization tool capable of generating entity-relationship diagrams from extract

Compromise is a natural language processing library and rule-based engine designed for English text manipulation, analysis, and parsing. It provides a toolkit for tokenizing text, identifying parts of speech, and performing linguistic analysis to achieve semantic understanding of unstructured strings. The project distinguishes itself through its ability to programmatically transform grammar, such as modifying verb tenses, noun plurality, and adjective forms. It also functions as a named entity recognizer capable of extracting people, places, organizations, dates, and contact information from

mycli is a MySQL command line client, database administration tool, and SQL query editor. It functions as a terminal interface for executing queries and managing MySQL connections, incorporating an integrated assistant that uses large language models to generate and analyze SQL statements based on the current database schema. The tool provides specialized query authoring capabilities, including context-sensitive syntax suggestions, fuzzy-matching identifier completion for tables and columns, and the ability to handover query buffers to external system text editors. It distinguishes its connec

This project is an educational implementation of a relational database engine written in C. It functions as a SQLite clone, demonstrating the internal mechanics of a database system through a C-based systems project that focuses on manual memory management and file I/O. The engine is distinguished by its use of a bytecode virtual machine, which executes database operations by compiling SQL statements into low-level instructions. It utilizes a B-tree database engine to organize records in a balanced tree structure, ensuring efficient insertion, search, and range scanning. The system covers co

snscrape is a Python-based social media web scraper and crawler designed to extract public posts, profiles, and hashtags from social networks without the use of official APIs. It functions as an archival tool and a utility for open-source intelligence data collection, allowing for the gathering of publicly available information to investigate trends and people. The tool facilitates social media data extraction for research and archival purposes, enabling the creation of historical records of conversations and user activity. It supports workflows for academic social analysis and the export of

Reader is a Win32 text reader and EPUB document viewer for Windows. It functions as an auto-scrolling text viewer and a web novel downloader that renders digital books and plain text using various character encodings. The application includes a text-based content filter to remove advertisements and irrelevant text from web sources using regular expressions. It provides hands-free reading capabilities through automated page-turning and scrolling modes governed by custom time intervals. The software manages digital book organization through reading progress tracking, bookmark management, and t

Movie Data Capture is a media library organizer and movie metadata scraper designed to automatically categorize and name files in a local media collection. It functions as an automated content tagger that identifies movie files and applies descriptive tags by extracting film details from web databases. The system utilizes an HTTP web scraper to fetch information from external APIs and remote HTML content. It employs a filename pattern parser to extract movie titles and release years from local files using regular expressions, which are then used to automate search queries. The tool maps scra

sqlean is a collection of SQLite extension libraries implemented as C-based shared libraries. It provides a suite of additional scalar and table-valued functions that expand the native capabilities of the SQLite database engine. The project provides specialized toolsets for cryptography, advanced mathematics, networking, and filesystem access. These include binary hashing and encoding, statistical analysis, IP address validation, and the ability to map CSV files or filesystem paths as virtual tables. The library also includes comprehensive text processing tools such as regular expressions, f

yidaRule is a website integration framework and rule repository designed to standardize how external platforms and applications connect to a core engine. It functions as a collection of JSON configuration rule-sets and web integration schemas that map external site behaviors and data patterns to a structured internal environment. The system utilizes a regex-based protocol parser to resolve and process magnet links, extracting file metadata and identifiers for media retrieval. It manages these interactions through a curated repository of rule files that define the specific logic required for d