Rails_db
Rails Database Viewer and SQL Query Runner
Overview:
Rails DB is a gem that offers a quick way to inspect a Rails database. Users can view the content of tables, export them to CSV, run SQL queries, and much more. The gem supports PostgreSQL, MySQL, and SQLite databases and can be used with ActiveRecord.
Features:
- Inspect Database: Easily view the content and schema of database tables, including indexes.
- Run SQL Queries: Execute SQL queries within the application with autocomplete support.
- Export to CSV: Export data from tables to CSV and Excel files.
- Filter and Sort Data: Filter and sort data in tables, with support for multiple filters.
- Customizable: Users can customize the gem through various options like enabling/disabling features and configuring HTTP_BASIC authentication.
- Visualize SQL Schema: (Future Feature) visualize the SQL schema for better understanding.
- CRUD Operations: (Future Feature) Perform CRUD operations on table records directly through the application.
