Short, unique, and human-readable IDs for ActiveRecord models with Sqids.

Sqinky adds a thin access layer on top of Sqids to work effortlessly with Sqids in Active Record models. It supports encodings composed of multiple attributes, and multiple encodings per model.

Add virtual attributes to an ActiveRecord model based on an SQL query.

Use builder pattern to create ad-hoc SQL queries that aren't tied to models but return read-only plain Ruby objects.

A Ruby client for sqlcached

Use ActiveRecord to execute SQL against any DB to export CSV

SqlGenius gives Rails apps a mountable performance dashboard for SQL databases. Monitor slow queries, analyze query statistics, detect unused and duplicate indexes, and explore your database with optional AI-powered optimization.

Adds REGEXP support for SQLite3 in ActiveRecord.

The SQLite3 adapter in Rails 4 doesn't support JSON columns. This gem adds it via a railtie and a series of hacks.

No more '...sqlite_master...' queries in your log when using sqlite

Full-text, vector, and hybrid search for ActiveRecord, without leaving SQLite. sqlite_search gives a model full-text search (FTS5 with BM25 ranking), vector search (sqlite-vec through the neighbor gem, with your app supplying embeddings), and hybrid search that fuses the two with Reciprocal Rank Fusion and an optional reranking step, all behind one declarative DSL. No search cluster to run, no separate copy of your data, no database triggers, and a schema that restores cleanly from schema.rb.

Include SqliteShards in an abstract Active Record class and its models read and write the SQLite file you pass to with_database, each file a shard of its own, migrated on first use.

Fork from ankane! Explore your data with SQL. Easily create charts and dashboards, and share them with your team.

SqlLoader allows you to keep your plain SQL queries as files instead of mixing them in your ActiveRecord models.

ActiveRecord extension that provides large performance improvements when you need large sets of read-only data and do not need the magic of ActiveRecord.

Query assertions and SQL matchers for RSpec.

This gem will help setup partitioning on a table, based on its `timestamp` column. Once you have a table that is partitioned based on a timestamp, you will likely need to regularly add new partitions into the future, and drop older partitions to free up space. This gem can help carry out such routine activities as well.

Provide #pluck_by_sql for Rails ActiveRecord models

A Ruby on Rails gem that analyzes SQL queries and suggests optimizations like missing indexes, inefficient sorts, and risky joins.

Do you use ActiveRecord::Connection.execute for speed sometimes? Does it bother you that the results are not mapped to your schema and type-cast as ActiveRecord would? Well that's what SQLRecord does.