query

MCP tool from Rails Ai Context by crisnahine

Safe read-only SQL with timeout, row limit, column redaction

How to use it

query is exposed by the Rails Ai Context MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the query tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.

FULL RAILS AI CONTEXT LISTING

Other tools in Rails Ai Context (39)

analyze_feature

Full-stack: models + controllers + routes + services + jobs + views + tests

dependency_graph

Model/service dependency graph in Mermaid or text format

generate_test

Test scaffolding matching your project's patterns

get_active_support

Concerns registry, deprecators, MessageVerifier usage, onload hooks, cache store

get_autoload

Zeitwerk mode, autoload/eager-load paths, collapsed dirs, custom inflections

get_callbacks

Callbacks in Rails execution order with source

get_component_catalog

ViewComponent/Phlex: props, slots, previews, sidecar assets

get_concern

Concern methods + source + which models include it

get_config

Database, auth framework, assets, cache, queue, Action Cable

get_context

Composite: schema + model + controller + routes + views in one call

get_controllers

Actions + inherited filters + render map + strong params

get_conventions

Auth checks, flash messages, create action template, test patterns

get_edit_context

Method-aware code extraction with class context

get_engines

Mounted engines (with known-engine descriptions) + loaded engine classes

get_env

Environment variables + credentials keys (not values)

get_env_config

Per-environment config: notable toggles + every config key each env sets

get_frontend_stack

React/Vue/Svelte/Angular, Hotwire, TypeScript, package manager

get_gems

Notable gems with versions, categories, config file locations

get_helper_methods

App + framework helpers with view cross-references

get_i18n

Locales, translation files with key counts, per-locale coverage, fallbacks

get_job_pattern

Queue, retries, guard clauses, broadcasts, schedules

get_mailers

Mailer classes with delivery actions and delivery method

get_model_details

AST-parsed associations, validations, scopes, enums, macros - each result tagged [VERIFIED] or [INFERRED]

get_partial_interface

What locals to pass + what methods are called on them

get_routes

Code-ready helpers (postpath(@record)) + required params

get_schema

Columns with indexed/unique/encrypted/default hints

get_service_pattern

Interface, dependencies, side effects, callers

get_stimulus

HTML data-attributes (dashes!) + targets + values + actions

get_test_info

Fixtures + relationships + test template matching your patterns

get_turbo_map

Broadcast → subscription wiring + mismatch warnings

get_view

Templates with ivars, Turbo wiring, Stimulus refs, partial locals

migration_advisor

Migration code generation with reversibility + affected models

onboard

Narrative app walkthrough (quick/standard/full)

performance_check

N+1 risks, missing indexes, countercache, eager load candidates

read_logs

Reverse file tail with level filtering and sensitive data redaction

search_code

Trace: definition + source + callers + tests. Also: definition, call, class filters

search_docs

Bundled topic index with weighted keyword search

security_scan

Brakeman static analysis - SQL injection, XSS, mass assignment

validate

Syntax + semantic + Brakeman security in one call