Ruby SQL

Open-source Ruby projects categorized as SQL | Edit details

Top 15 Ruby SQL Projects

  • ransack

    Object-based searching.

    Project mention: ransack VS Searchkick - a user suggested alternative | | 2021-08-12
  • Blazer

    Business intelligence made simple

    Project mention: Cookie-based tracking is dead | | 2021-12-16

    I did server-side tracking test in a rails app, where I implemented a tracking gem called ahoy and blazer for visualization. It is very easy to set up, but a bit hard to use. Blazer can do a very basic visualization of the data if you know your SQL queries.

  • SonarQube

    Static code analysis for 29 languages.. Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.

  • Scenic

    Versioned database views for Rails

    Project mention: Frameworks for SQL Development in Rails? | | 2021-10-05

    I use the scenic gem to manage views which uses raw sql files:

  • ROM

    Data mapping and persistence toolkit for Ruby

    Project mention: Catching up on things | | 2021-12-19

    Better gems. dry-rb, ROM, and Hanami are doing interesting stuff. I also hear web_pipe is popular?

  • 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.

    Project mention: Rails application boilerplate for fast MVP development | | 2021-08-06

    lol_dba for indexing

  • Motor Admin

    Deploy a no-code admin panel for your application in less than a minute. Stop wasting time on custom internal tools and focus on the actual product. Motor Admin allows to launch a custom admin panel for any application.

    Project mention: Motor Admin - An Open Source no-code admin panel for your application | | 2021-12-17


  • SQL Server

    SQL Server Adapter For Rails

  • OPS

    OPS - Build and Run Open Source Unikernels. Quickly and easily build and deploy open source unikernels in tens of seconds. Deploy in any language to any cloud.

  • TinyTDS

    TinyTDS - Simple and fast FreeTDS bindings for Ruby using DB-Library.

  • BabySqueel

    :pig: An expressive query DSL for Active Record 4 and 5

  • motor-admin-rails

    Low-code Admin panel and Business intelligence Rails engine. No DSL - configurable from the UI.

    Project mention: From Node to Ruby on Rails | | 2021-12-16

    I think the coolest thing about Rails is actually the great amount of high quality Ruby gems for Rails.

    For instance, you can bootstrap a powerful Admin panel for your Rails project in no time with gem.

  • PpSql

    Rails ActiveRecord SQL queries log beautifier

  • rom-sql

    SQL support for rom-rb

  • ActiveRecord Where Assoc

    Make ActiveRecord do conditions on your associations

    Project mention: My new gem lets you follow associations when doing ActiveRecord queries. Here's an intro for follow_assoc. | | 2021-09-29

    Your examples using joins would return duplicated Sections. That might force you to add a distinct. I personally find it wrong to do a distinct in a scope just to be able to make the condition I want the scope to do. It's a hidden side effect that could cause problem elsewhere and it's unexpected from the name of the scope. I made a gem to deal with that situation: where_assoc. There is definitely an overlap between both gem.

  • ActiveRecord Setops

    Union, Intersect, and Difference set operations for ActiveRecord (also, SQL's UnionAll).

  • activerecord_follow_assoc

    Follow associations within your ActiveRecord queries

    Project mention: My new gem lets you follow associations when doing ActiveRecord queries. Here's an intro for follow_assoc. | | 2021-09-29
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). The latest post mention was on 2021-12-19.

Ruby SQL related posts


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

Project Stars
1 ransack 5,049
2 Blazer 3,123
3 Scenic 2,866
4 ROM 1,969
5 Lol DBA 1,411
6 Motor Admin 1,008
7 SQL Server 935
8 TinyTDS 579
9 BabySqueel 385
10 motor-admin-rails 317
11 PpSql 233
12 rom-sql 187
13 ActiveRecord Where Assoc 150
14 ActiveRecord Setops 18
15 activerecord_follow_assoc 12
Find remote jobs at our new job board There are 29 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.
Less time debugging, more time building
Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.