rails_query
Run read-only SQL SELECT queries against a Rails app database to inspect data patterns, verify migrations, and debug data issues, with validation, timeouts, and row limits.
Instructions
Execute read-only SQL queries against the database. Use when: checking data patterns, verifying migrations, debugging data issues. Safety: SQL validation + database-level READ ONLY + statement timeout + row limit. Development/test only by default. Key params: sql (SELECT only), limit (default 100), format (table/csv).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | SQL query to execute. Only SELECT, WITH, SHOW, EXPLAIN, DESCRIBE allowed, and no UNION. | |
| limit | No | Max rows to return. Default: 100, hard cap: 1000. | |
| format | No | Output format. table: markdown table (default). csv: comma-separated values. | |
| explain | No | Run EXPLAIN on the query. Returns execution plan analysis instead of data. SELECT only. | |
| database | No | The app database to query, by its config/database.yml name (for example queue). Default: the primary. |