SQL, or Structured Query Language, is a standardized language used for managing and manipulating relational databases, making it a fundamental tool for application developers who work with data storage and retrieval. SQL enables developers to perform a wide range of tasks, such as querying data from tables using SELECT statements, inserting new records with INSERT, updating existing records using UPDATE, and deleting records with DELETE. Additionally, SQL provides powerful functions for data summarization, such as GROUP BY and aggregate functions, which simplify complex data analysis tasks. Beyond data manipulation, SQL also facilitates database schema management through statements like CREATE, ALTER, and DROP, allowing developers to define and modify the structure of the database. Its cross-platform support and wide adoption make SQL an essential skill, offering developers the ability to interact with various relational database management systems like MySQL, PostgreSQL, Oracle, and SQL Server, ensuring robust and efficient data-driven applications.
View the most prominent open source SQL projects in the list below. Click on a specific project to view its alternative or complementary packages. Make comparisons and find the best package for your app.
- Linux, Jenkins, AWS, SRE, Prometheus, Docker, Python, Ansible, Git, Kubernetes, Terraform, OpenStack, SQL, NoSQL, Azure, GCP, DNS, Elasti…☆78,247Updated 2 weeks ago
- Free universal database tool and SQL client☆45,348Updated this week
- ClickHouse® is a real-time analytics database management system☆42,856Updated this week
- Apache Spark - A unified analytics engine for large-scale data processing☆41,897Updated this week
- TiDB - the open-source, cloud-native, distributed SQL database designed for modern applications.☆39,033Updated this week
- This is a repo with links to everything you'd ever want to learn about data engineering☆37,643Updated 3 weeks ago
- Free, simple, and intuitive online database diagram editor and SQL generator.☆32,691Updated this week
- The flexible backend for all your projects 🐰 Turn your DB into a headless CMS, admin panels, or apps with a custom UI, instant APIs, aut…☆32,295Updated this week
- DuckDB is an analytical in-process SQL database management system☆32,807Updated this week
- CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placemen…☆31,281Updated this week
- Feature-rich ORM for modern Node.js and TypeScript, it supports PostgreSQL (with JSON and JSONB support), MySQL, MariaDB, SQLite, MS SQL …☆30,160Updated 2 weeks ago
- A scalable, distributed, collaborative, document-graph database, for the realtime web☆30,055Updated this week
- Headless TypeScript ORM with a head. Runs on Node, Bun and Deno. Lives on the Edge and yes, it's a JavaScript ORM too 😅☆30,287Updated this week
- REST API for any Postgres database☆25,727Updated this week
- Apache Flink☆25,256Updated this week
- 🔥🔥超过1000本的计算机经典书籍、个人笔记资料以及本人在各平台发表文章中所涉及的资源等。书籍资源包括C/C++、Java、Python、Go语言、数据结构与算法、操作系统、后端架构、计算机系统知识、数据库、计算机网络、设计模式、前端、汇编以及校招社招各种面经~☆24,673Updated 2 months ago
- High-performance, scalable time-series database designed for Industrial IoT (IIoT) scenarios☆24,326Updated this week
- SQL powered operating system instrumentation, monitoring, and analytics.☆22,721Updated last week
- Chat with your database or your datalake (SQL, CSV, parquet). PandasAI makes data analysis conversational using LLMs and RAG.☆22,029Updated last month
- Empowering Data Intelligence with Distributed SQL for Sharding, Scalability, and Security Across All Databases.☆20,448Updated this week
- Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.☆20,593Updated this week
- MyBatis SQL mapper framework for Java☆20,229Updated this week
- A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.☆20,008Updated 3 weeks ago
- 🤖 Chat with your SQL database 📊. Accurate Text-to-SQL Generation via LLMs using RAG 🔄.☆20,327Updated 5 months ago
- A time-series database for high-performance real-time analytics packaged as a Postgres extension☆20,143Updated this week
- Dolt – Git for Data☆19,057Updated last week
- 📊 Cube’s universal semantic layer platform is the next evolution of OLAP technology for AI, BI, spreadsheets, and embedded analytics☆18,883Updated this week
- Dapper - a simple object mapper for .Net☆18,053Updated 3 months ago
- Database diagrams editor that allows you to visualize and design your DB with a single query.☆18,755Updated this week
- Database migrations. CLI and Golang library.☆17,382Updated 2 weeks ago
- Bitwarden infrastructure/backend (API, database, Docker, etc).☆17,169Updated this week
- The lightweight, user-friendly, distributed relational database built on SQLite.☆16,944Updated last week
- SQL databases in Python, designed for simplicity, compatibility, and robustness.☆16,751Updated this week
- The official home of the Presto distributed SQL query engine for big data☆16,498Updated this week
- 👶🏻 신입 개발자 전공 지식 & 기술 면접 백과사전 📖☆16,521Updated 3 months ago
- QuestDB is a high performance, open-source, time-series database☆16,074Updated last week
- Generate type-safe code from SQL☆15,940Updated this week
- 🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, …☆15,647Updated this week
- Transform data, train models, and run SQL with marimo — feels like a next-gen reactive notebook, stored as Git-friendly reproducible Pyth…☆15,865Updated this week
- Go MySQL Driver is a MySQL driver for Go's (golang) database/sql package☆15,084Updated 3 months ago