Log MySQL queries with EXPLAIN that may be slow.

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

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

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

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

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.

SQLRunner allows you to load your queries out of SQL files, without using ORMs.

A gem that allows for simple SQL-based search and sort functionality

Sequence number generation in Rails

The author was too lazy to write a description

Retrieve SQL values using Active Record query interface but without instantiation of AR-objects