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.

With SQLreport you can manage query results and convert things.

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

Debug SQL statements in ActiveRecord by displaying warnings on bad queries.

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

Squeel unlocks the power of ARel in your Rails 3 application with a handy block-based syntax. You can write subqueries, access named functions provided by your RDBMS, and more, all without writing SQL strings. I'm trying to push a version of this gem, so that bundler doesn't screw up with the :git included versions.

"Squirm facilitates using Postgres stored procedures with Active Record."

Write-through and Read-through Cacheing for ActiveRecord

Provide simple helpers on persist values in redis for performance. Works with ActiveRecord.

Stackflame provides a simple API to deal with Flamegraph of stackprof.