The sqlite print table gem is used to print a formatted table from a sqlite database using a SQL query.

SQLiterate is a SQL parser.

have u ever wanted to shout SELECTed words??? now u can. UPDATE ur noob sql scripting FROM lowercase to uppercase

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

A simple gem to track metric events in your own postgres or Amazon Redshift database.

Simple standalone migrations you can use with plain SQL

SQL Optimizer helps you optimize you queries and see full description

A Racc-based Ruby parser for SQL statements; forked from https://github.com/cryodex/sql-parser

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.

A mini-language for building and executing SQL statements against a postgresql database. This is a very old library, pre-dating active record and lacking many of its refinments. New projects will probably not want to use it.

A c++ table class wrapper generator for sqlpp11 (c++11). See more about sqlpp11

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

Gem to run SQL like queries on array of hashes or similar objects

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.

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

Sequence number generation in Rails

sql_tagger inserts stack trace comments into SQL queries.

Uses built-in mysql commands for dumping/loading of plain text fixtures and schema.

runs sqltests for CBS Testing environment

A shortcut to the COPY command from PostgreSQL. Give it SQL and get an Enumerator for the CSV that comes out of it.