The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning. Learn more →
Top 23 Database Tool Open-Source Projects
-
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.
-
Database Cleaner
Strategies for cleaning databases in Ruby. Can be used to ensure a clean state for testing.
-
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.
-
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.
-
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.
-
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.
-
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).
-
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).
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
I am using https://github.com/ankane/pghero/ and this is one of its features with GUI
In the Rails world, the gem strong_migrations can be used to detect these: https://github.com/ankane/strong_migrations
The docs include a handy articulation of fixes.
gem "lol_dba" - https://github.com/plentz/lol_dba | Inspect the state of table indexes.
Great write up! At PeerDB, we’ve been using refinery https://github.com/rust-db/refinery to handle database migrations of our catalog Postgres database from Rust. It is easy, typesafe and gets the job done. Thought this would be useful for users building apps with Rust!
Project mention: Greenmask: PostgreSQL Dump and Obfuscation Tool | news.ycombinator.com | 2024-02-17This is a Rails tool I use: https://github.com/IFTTT/polo — it works well.
Project mention: auto_strip_attributes VS attribute_normalizer - a user suggested alternative | libhunt.com/r/auto_strip_attributes | 2023-06-06
Database Tools related posts
- Show HN: PostgreSQL Index Advisor
- Careful with That Lock, Eugene
- Ocra: One-Click Ruby Application Builder
- Blazer: Business Intelligence Made Simple
- Is Tableau Dead?
- Greenmask: PostgreSQL Dump and Obfuscation Tool
- Must-have gems for mature Rails
-
A note from our sponsor - WorkOS
workos.com | 26 Apr 2024
Index
What are some of the best open-source Database Tool projects? This list will help you:
Project | Stars | |
---|---|---|
1 | PgHero | 7,695 |
2 | Blazer | 4,375 |
3 | Mongoid | 3,917 |
4 | strong_migrations | 3,856 |
5 | Scenic | 3,338 |
6 | Database Cleaner | 2,913 |
7 | Large Hadron Migrator | 1,816 |
8 | active_record_doctor | 1,630 |
9 | Lol DBA | 1,571 |
10 | Squasher | 1,466 |
11 | Rails DB | 1,453 |
12 | Seed dump | 1,390 |
13 | Foreigner | 1,327 |
14 | Seed Fu | 1,215 |
15 | refinery | 1,205 |
16 | Seedbank | 1,137 |
17 | BatchLoader | 1,019 |
18 | DatabaseConsistency | 981 |
19 | Polo | 765 |
20 | Upsert | 657 |
21 | online_migrations | 579 |
22 | DatabaseValidations | 500 |
23 | auto_strip_attributes | 355 |
Sponsored