Rust SQL

Open-source Rust projects categorized as SQL

Top 23 Rust SQL Projects

  1. surrealdb

    A scalable, distributed, collaborative, document-graph database, for the realtime web

    Project mention: SurrealDB 2.2: Benchmarking, graph path algorithms and foreign key constraints | dev.to | 2025-03-17

    To make this better, we've created a language testing suite similar to the ECMAscript conformance testing suite test262.

  2. CodeRabbit

    CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.

    CodeRabbit logo
  3. cube.js

    📊 Cube’s universal semantic layer platform is the next evolution of OLAP technology for AI, BI, spreadsheets, and embedded analytics

    Project mention: 10 of the Best Web Analytics Tools for React Websites | dev.to | 2025-03-20

    Cube is a headless business intelligence tool for building analytical web apps quickly and efficiently. Data modeling, access control, APIs, and caching are the four main features of Cube. It offers analytical API servers with query orchestration and multi-level caching capabilities.

  4. sqlx

    🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite. (by launchbadge)

    Project mention: You Probably Don't Need Query Builders | news.ycombinator.com | 2025-01-25

    Because type correctness does not imply branch correctness. SQL has side effects of interpretation, and any string/query builder that is not aware of grammatical implications should be avoided in my opinion.

    Check the query builder of sqlx [1]

    [1] https://github.com/launchbadge/sqlx/blob/main/sqlx-core/src/...

  5. diesel

    A safe, extensible ORM and Query Builder for Rust

    Project mention: drizzle + sqlite in Tauri App | dev.to | 2025-03-20

    Tauri's backend is in Rust, so I always thought the only way to use sqlite ORM in a Tauri app is with projects like diesel or prisma-client-rust, which could be hard because they are in rust. What is even harder is sqlite db encryption. Both of the 2 ORMs don't support cipher encryption, thus I had to write raw sql queries in kunkun Example Maintaining raw sql queries is a nightmare to me, especially when it comes to schema migration. I have to rely on thorough testing to make sure everything is correct. There is no type checking.

  6. prql

    PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement

    Project mention: SQL queries don't start with SELECT (2019) | news.ycombinator.com | 2025-03-14
  7. limbo

    Limbo is a project to build the modern evolution of SQLite.

    Project mention: Turso SQLite Offline Sync Public Beta | news.ycombinator.com | 2025-03-31

    > they seem to intend to Embrace Extend Extinguish

    What makes you think that? Limbo is MIT licensed and I don't see any CLA on [1].

    [1]: https://github.com/tursodatabase/limbo/blob/main/CONTRIBUTIN...

  8. sea-orm

    🐚 An async & dynamic ORM for Rust

    Project mention: Toasty, an Async ORM for Rust | news.ycombinator.com | 2024-10-23
  9. InfluxDB

    InfluxDB high-performance time series database. Collect, organize, and act on massive volumes of high-resolution data to power real-time intelligent systems.

    InfluxDB logo
  10. risingwave

    Stream processing and management platform.

    Project mention: Simplifying SQL function implementation with Rust procedural macro | dev.to | 2025-03-13

    Then, utilize declarative macros to generate various types of kernel functions, including functions with 1, 2, and 3 parameters, as well as the input/output combinations of T and Option. Common kernels like unary, binary, ternary, unary_nullable and unary_bytes are generated, partially addressing the last two issues. (For the implementation details, see RisingWave's earlier code.) Theoretically, type exercise could also be used here. For example, introducing a trait to unify (A,), (A, B) and (A, B, C), or utilizing traits of Into and AsRef to unify T, Option, and Result, etc. However, you will probably encounter some type challenges posed by rustc.

  11. datafusion

    Apache DataFusion SQL Query Engine

    Project mention: Apache Datafusion – An extensible query engine in Rust that uses Apache Arrow | news.ycombinator.com | 2025-04-15
  12. paradedb

    ParadeDB is a modern Elasticsearch alternative built on Postgres. Built for real-time, update-heavy workloads.

    Project mention: Meilisearch – search engine API bringing AI-powered hybrid search | news.ycombinator.com | 2025-04-14

    - https://github.com/paradedb/paradedb

    I'm still looking for a systematic approach to make a hybrid search (combined full-text with vectors).

    Any thoughts on up-to-date hybrid search experience are greatly appreciated

  13. toydb

    Distributed SQL database in Rust, written as an educational project

  14. postgresml

    Postgres with GPUs for ML/AI apps.

    Project mention: Postgres Learns to RAG: Wikipedia Q&A using Llama 3.1 inside the database | news.ycombinator.com | 2024-09-24

    GitHub: https://github.com/postgresml/postgresml

    Looking forward to your feedback and any questions about the technical details.

  15. materialize

    Real-time Data Integration and Transformation: use SQL to transform, deliver, and act on fast-changing data. (by MaterializeInc)

    Project mention: Turning the Database Inside-Out | news.ycombinator.com | 2025-01-28

    https://materialize.com/ provides another approach, based on "timely dataflow" (https://timelydataflow.github.io/timely-dataflow/) - originated at MS.

  16. readyset

    Readyset is a MySQL and Postgres wire-compatible caching layer that sits in front of existing databases to speed up queries and horizontally scale read throughput. Under the hood, ReadySet caches the results of cached select statements and incrementally updates these results over time as the underlying data changes.

    Project mention: How to Make Your Postgres Database 100x Faster and 50% Cheaper with Readyset Cloud🚀⚡💵 | dev.to | 2025-02-27

    I also faced similar issues and was looking for easy ways to improve performance in our application when I came across an awesome tool called Readyset. It sits between your application and database, intelligently caching complex queries while automatically handling invalidation. This setup can significantly boost performance without requiring major changes to your existing infrastructure.

  17. greptimedb

    An open-source, cloud-native, unified observability database for metrics, logs and traces, supporting SQL/PromQL/Streaming. Available on GreptimeCloud.

    Project mention: Development Environment Configuration | dev.to | 2025-01-19

    Time Series: Greptime, Influx, Loki, Mimir, Prometheus, Tempo, Victoria Metrics

  18. fselect

    Find files with SQL-like queries

  19. arroyo

    Distributed stream processing engine in Rust

  20. rust-postgres

    Native PostgreSQL driver for the Rust programming language

  21. rusqlite

    Ergonomic bindings to SQLite for Rust

    Project mention: Show HN: SQLite Transaction Benchmarking Tool | news.ycombinator.com | 2024-07-17
  22. quadratic

    Spreadsheet with AI, Code, Connections

    Project mention: Cursed Excel: “1/2”+1=45660 | dev.to | 2025-04-08

    Using a proper datetime system has the added bonus of letting us represent dates much farther in the past than 1900, although I'd be careful with anything before 1582. Building a spreadsheet from scratch is challenging and takes a long time to get right, so if you have a use case we don't support yet, let us know on our community forums or submit a code contribution on GitHub!

  23. GQL

    GitQL is a extensible SQL-like query language and SDK to perform queries on various data sources such .git files with supports of most of SQL features such as grouping, ordering and aggregation and window functions and allow customization like user-defined types and functions

  24. roapi

    Create full-fledged APIs for slowly moving datasets without writing a single line of code.

    Project mention: Show HN: Turn CSS files into high performance APIs | news.ycombinator.com | 2025-01-11
  25. pg_graphql

    GraphQL support for PostgreSQL

    Project mention: Modern Web Development Sucks? How PostgreSQL Can Replace Your Tech Stack | dev.to | 2025-03-05

    Want a GraphQL API without the hassle of setting up Apollo Server or Hasura? With the pg_graphql extension, PostgreSQL itself becomes your GraphQL backend—no extra servers, no complex configurations, just pure SQL.

  26. SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020).

Rust SQL discussion

Log in or Post with

Rust SQL related posts

Index

What are some of the best open-source SQL projects in Rust? This list will help you:

# Project Stars
1 surrealdb 29,104
2 cube.js 18,433
3 sqlx 14,519
4 diesel 13,264
5 prql 10,208
6 limbo 10,147
7 sea-orm 8,062
8 risingwave 7,636
9 datafusion 7,008
10 paradedb 6,968
11 toydb 6,392
12 postgresml 6,235
13 materialize 5,951
14 readyset 4,928
15 greptimedb 4,865
16 fselect 4,163
17 arroyo 4,253
18 rust-postgres 3,659
19 rusqlite 3,529
20 quadratic 3,489
21 GQL 3,396
22 roapi 3,282
23 pg_graphql 3,085

Sponsored
CodeRabbit: AI Code Reviews for Developers
Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
coderabbit.ai