Ruby Database Tools

Open-source Ruby projects categorized as Database Tools

Top 23 Ruby Database Tool Projects

  • PgHero

    A performance dashboard for Postgres

    Project mention: What are your favourite approaches to keeping on top of Postgres health? | /r/rails | 2023-06-27

    I use either PgHero or Rails PG Extras on every project

  • Blazer

    Business intelligence made simple

    Project mention: Blazer: Business Intelligence Made Simple | news.ycombinator.com | 2024-02-27
  • PopRuby

    PopRuby: Clothing and Accessories for Ruby Developers. Fashion meets Ruby! Shop our fun Ruby-inspired apparel and accessories designed to celebrate the joy and diversity of the Ruby community.

  • Mongoid

    The Official Ruby Object Mapper for MongoDB

  • strong_migrations

    Catch unsafe migrations in development

    Project mention: Must-have gems for mature Rails | dev.to | 2024-02-02

    gem "strong_migrations" - https://github.com/ankane/strong_migrations | Helps devs write non-blocking migrations, a must-have.

  • Scenic

    Versioned database views for Rails

  • Database Cleaner

    Strategies for cleaning databases in Ruby. Can be used to ensure a clean state for testing.

  • Large Hadron Migrator

    Online MySQL schema migrations

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  • active_record_doctor

    Identify database issues before they hit production.

  • 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: Must-have gems for mature Rails | dev.to | 2024-02-02

    gem "lol_dba" - https://github.com/plentz/lol_dba | Inspect the state of table indexes.

  • Squasher

    Squasher - squash your old migrations in a single command

  • Seed dump

    Rails 4/5 task to dump your data to db/seeds.rb

  • Foreigner

    Adds foreign key helpers to migrations and correctly dumps foreign keys to schema.rb

  • Seed Fu

    Advanced seed data handling for Rails, combining the best practices of several methods together.

  • Seedbank

    Seedbank gives your seed data a little structure. Create seeds for each environment, share seeds between environments and specify dependencies to load your seeds in order. All nicely integrated with simple rake tasks.

  • BatchLoader

    :zap: Powerful tool for avoiding N+1 DB or HTTP queries

  • DatabaseConsistency

    The tool to avoid various issues due to inconsistencies and inefficiencies between a database schema and application models.

  • Polo

    Polo travels through your database and creates sample snapshots so you can work with real world data in development.

    Project mention: Greenmask: PostgreSQL Dump and Obfuscation Tool | news.ycombinator.com | 2024-02-17

    This is a Rails tool I use: https://github.com/IFTTT/polo — it works well.

  • Upsert

    Upsert on MySQL, PostgreSQL, and SQLite3. Transparently creates functions (UDF) for MySQL and PostgreSQL; on SQLite3, uses INSERT OR IGNORE.

  • online_migrations

    Catch unsafe PostgreSQL migrations in development and run them easier in production (code helpers for table/column renaming, changing column type, adding columns with default, background migrations, etc).

    Project mention: Migration Magic ✨, Handling Not-Null Constraints in Production with Ruby on Rails | /r/rails | 2023-04-05

    Or simply use https://github.com/fatkodima/online_migrations and don’t get bitten by migrations in production again.

  • DatabaseValidations

    Database validations for ActiveRecord

  • auto_strip_attributes

    AutoStripAttributes gem for Rails helps to remove unnecessary whitespaces from ActiveRecord or ActiveModel attributes. It's good for removing accidental spaces from user inputs (e.g. when user copy/pastes some value to a form and the value has extra spaces at the end).

    Project mention: auto_strip_attributes VS attribute_normalizer - a user suggested alternative | libhunt.com/r/auto_strip_attributes | 2023-06-06
  • Shiba

    Catch bad SQL queries before they cause problems in production

  • QueryTrack

    Find time-consuming database queries for ActiveRecord-based Rails Apps

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

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 2024-02-27.

Ruby Database Tools related posts

Index

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

Project Stars
1 PgHero 7,516
2 Blazer 4,299
3 Mongoid 3,917
4 strong_migrations 3,797
5 Scenic 3,309
6 Database Cleaner 2,911
7 Large Hadron Migrator 1,810
8 active_record_doctor 1,599
9 Lol DBA 1,565
10 Squasher 1,454
11 Seed dump 1,393
12 Foreigner 1,335
13 Seed Fu 1,215
14 Seedbank 1,135
15 BatchLoader 1,013
16 DatabaseConsistency 973
17 Polo 765
18 Upsert 657
19 online_migrations 565
20 DatabaseValidations 498
21 auto_strip_attributes 355
22 Shiba 293
23 QueryTrack 290
The modern identity platform for B2B SaaS
The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
workos.com