Open Source SQL Projects
SQL is a language for defining, querying, and managing data in relational databases. It lets people retrieve specific records, combine information across tables, update data, and describe structures using a widely adopted set of conventions. SQL is used in applications, reporting, analytics, and data workflows, helping teams work with structured information consistently and efficiently.
Open source tools in this area include database systems, query editors, parsers, formatters, data libraries, and object-relational mapping tools. When choosing one, consider its license, maturity, maintenance activity, supported SQL dialects, performance needs, security practices, and compatibility with your existing systems. These tools are useful for developers, database administrators, analysts, and organizations building or maintaining data-driven applications.
9 repositories · updated July 29, 2026
sqlparse: A Powerful Non-Validating SQL Parser for Python
sqlparse is a robust, non-validating SQL parser module for Python, designed to tokenize SQL text and group its components into a structured tree. It serves as a foundational tool for building formatters, linters, and query analysis applications. Developers can leverage its capabilities to split SQL scripts, format statements, and deeply inspect their token trees.
ds-cheatsheets: Your Ultimate Collection of Data Science Cheatsheets
The ds-cheatsheets repository by FavioVazquez offers an extensive collection of quick reference guides for data science. It covers a broad spectrum of topics, including programming languages like Python and R, and advanced concepts in Machine Learning and Deep Learning. This resource is perfect for anyone needing a handy guide to navigate the complex world of data science.
dataset: Easy-to-Use Data Handling for SQL in Python
Dataset is a Python library designed to simplify data handling for SQL data stores. It offers features like implicit table creation, bulk loading, and transaction support, making database interactions as straightforward as working with JSON files.
ClickHouse: Real-time Analytics Database Management System for Big Data
ClickHouse is an open-source, column-oriented database management system specifically engineered for generating analytical data reports in real-time. It is highly regarded for its exceptional performance in processing large volumes of data, making it a powerful solution for modern big data analytics. With over 45,000 stars on GitHub, it stands as a leading choice in the analytics database landscape.
WhoDB: A Lightweight, AI-Powered Database Explorer for Modern Developers
WhoDB is a modern, lightweight database management tool built with GoLang and React, offering fast performance and an intuitive interface. It supports a wide range of databases, including SQL and NoSQL, and features AI-powered natural language queries. Designed for developers, data analysts, and DBAs, WhoDB simplifies database interaction and management.
SQLModel: Simplifying SQL Databases in Python with Pydantic and SQLAlchemy
SQLModel is a Python library designed for intuitive, compatible, and robust interaction with SQL databases. Built on Pydantic and SQLAlchemy, it streamlines database operations, especially within FastAPI applications, by leveraging Python type annotations. It aims to minimize code duplication and enhance developer experience with excellent editor support.
CSSQL: Convert SQL to CSS with this Esoteric Programming Language
CSSQL is a unique "esoteric" programming language and compiler that allows developers to write CSS using a SQL DDL-like syntax. It reimagines CSS selectors as relational database tables, providing a novel approach to styling files. Written in Haskell, CSSQL is also made available for JavaScript environments via GHCJS.
Apple Health MCP: Query Your Apple Health Data with Natural Language and SQL
The `apple-health-mcp` project is an MCP (Model Context Protocol) server designed for querying Apple Health data. It allows users to analyze their health metrics using natural language or direct SQL queries. This server integrates with clients like Claude Desktop, providing powerful tools for health data analysis.
ChartDB: Visualize and Design Your Database with a Single Query
ChartDB is an open-source, web-based database diagramming editor designed to visualize and design your database schemas instantly. It generates diagrams from a single "Smart Query" and offers AI-powered export for seamless migrations across various database types, all without requiring installation or database passwords.