InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now. Learn more →
Top 23 Ruby SQL Projects
-
-
InfluxDB
InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
-
-
1) First, let's install the Scenic gem. It's not required, but it gives us nice ways to create and manage views.
-
-
Lol DBA
lol_dba is a small package of rake tasks that scan your application models and displays a list of columns that probably should be indexed. Also, it can generate .sql migration scripts.
-
-
motor-admin-rails
Low-code Admin panel and Business intelligence Rails engine. No DSL - configurable from the UI. Rails Admin, Active Admin, Blazer modern alternative.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
-
-
-
-
-
-
-
Also, GitHub ⭐s for our Ruby library are very much welcome!
-
Refer to the documentation for more details.
-
If you use ROM, you won't be able to use factory bot, instead there is rom factory
-
-
Project mention: A simple tool to observe PostgreSQL database locks in Rails apps | news.ycombinator.com | 2024-09-05
-
-
-
ThinkDB
ThinkDB is an easy-to-use SQL client that makes working with your databases simpler and more efficient. Whether you're a database pro or just getting started, ThinkDB's intuitive interface helps you explore, query, and manage your data with ease.
With sqlite and docker.. rails apps are easy to share.. my last project is easy to install and use because of rails https://github.com/ThinkThinkAI/ThinkDB
# change directory_on_your_machine_for_think_db_storage
-
ActiveRecord Setops
Union, Intersect, and Difference set operations for ActiveRecord (also, SQL's UnionAll).
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
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).
Ruby SQL discussion
Ruby SQL related posts
-
⚙️ Building a better Ruby ORM for time series and analytics
-
liquibase alternatives - Logidze and dolt
3 projects | 19 Nov 2024 -
SQLite on Rails: The how and why of optimal performance
-
Query multiple tables easily with Rails and Postgres Views
-
How to avoid N+1 query using SQL views (materialized) in Rails application
-
Blazer: Business Intelligence Made Simple
-
Is Tableau Dead?
-
A note from our sponsor - InfluxDB
www.influxdata.com | 13 May 2025
Index
What are some of the best open-source SQL projects in Ruby? This list will help you:
| # | Project | Stars |
|---|---|---|
| 1 | ransack | 5,759 |
| 2 | Blazer | 4,654 |
| 3 | Scenic | 3,507 |
| 4 | ROM | 2,095 |
| 5 | Lol DBA | 1,584 |
| 6 | SQL Server | 979 |
| 7 | motor-admin-rails | 799 |
| 8 | TinyTDS | 618 |
| 9 | BabySqueel | 502 |
| 10 | boxcars | 451 |
| 11 | occams-record | 372 |
| 12 | PpSql | 270 |
| 13 | ActiveRecord Where Assoc | 239 |
| 14 | rom-sql | 218 |
| 15 | timescaledb-ruby | 111 |
| 16 | fluent-plugin-sql | 111 |
| 17 | rom-factory | 81 |
| 18 | activerecord-originator | 73 |
| 19 | pg-locks-monitor | 63 |
| 20 | acts_as_nosql | 35 |
| 21 | active_record_distinct_on | 34 |
| 22 | ThinkDB | 27 |
| 23 | ActiveRecord Setops | 22 |
Sponsored
InfluxDB – Built for High-Performance Time Series Workloads
InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
www.influxdata.com