SQL — 123 Operations for AI Agents

This page is the canonical reference an AI coding agent uses to refactor, query, and analyze SQL code through the act MCP server. 123 operations available: 49 refactor, 18 query, 42 analysis, 14 verification. Each operation is callable from Claude Code, Cursor, Codex, OpenCode, or any MCP-compatible agent host. Click any operation for a stable anchor link suitable for citation.

18Query

49Refactor

42Analysis

14Verify

Query

18 query tools, the same on every supported language. Descriptions live in the shared reference: /docs/query-tools.

callers control_flow data_flow definition diagnostics effect_closure effect_summary fix_auto get_type graph import_organize interface mutations references repo_outline skeleton symbols symbols_batch

Refactor

Operation	Description
`add-column-alias`	Add an AS alias to a column in the SELECT list
`add-distinct-when-needed`	Add DISTINCT when duplicates indicate error
`add-group-by-clause`	Add GROUP BY clause
`add-table-alias`	Add explicit table aliases to tables in FROM clause
`consolidate-case-expression`	Consolidate redundant CASE expressions
`consolidate-redundant-joins`	Consolidate redundant JOIN operations
`convert-having-to-where`	Move HAVING conditions to WHERE when they filter ungrouped data
`convert-inner-join-to-left`	Convert INNER JOIN to LEFT JOIN
`convert-union-all-to-union`	Convert UNION ALL to UNION by removing duplicates
`convert-union-to-union-all`	Convert UNION to UNION ALL
`expand-select-star`	Expand SELECT * to explicit columns
`extract-column-expression`	Extract computed column expression
`extract-common-table-expression`	Extract a repeated subquery to a Common Table Expression
`extract-scalar-subquery`	Extract scalar subquery to CTE
`extract-subquery-to-cte`	Extract a subquery to a Common Table Expression
`extract-where-condition`	Extract WHERE condition to CTE
`extract_function`	Extract a code selection into a new function — automatically infers parameters, return types, and inserts the call site. Use instead of manually cutting/pasting code. Works without LSP; LSP improves type inference. Params: file (string), new_name (string), start_line (u32), start_column (u32), end_line (u32), end_column (u32) [, preview (bool), receipt (bool)]
`extract_variable`	Extract an expression into a named variable — inserts the declaration and replaces the expression with the variable name. Works without LSP. Params: file (string), new_name (string), start_line (u32), start_column (u32), end_line (u32), end_column (u32) [, preview (bool)]
`flatten-nested-subqueries`	Flatten nested subqueries into JOINs
`generate-column-list`	Generate column list
`generate-comparison-predicate`	Generate comparison predicate
`generate-create-index`	Generate CREATE INDEX statement for table columns
`generate-create-table`	Generate CREATE TABLE statement from column definitions
`generate-cte-template`	Generate CTE template
`generate-delete-statement`	Generate DELETE statement
`generate-insert-statement`	Generate INSERT statement
`generate-select-all`	Generate SELECT * statement
`generate-union-query`	Generate UNION query template
`generate-update-statement`	Generate UPDATE statement
`inline`	Inline a variable, function, or method — replace every usage with its definition body, then remove the original. The inverse of extract. Works without LSP (single-file); LSP enables cross-file inlining. Params: file (string), symbol (string) [, line (u32), preview (bool), receipt (bool)]
`inline-cte`	Inline a Common Table Expression back into the query
`inline-simple-expression`	Inline simple expressions
`insert_body`	Replace a function's implementation body with new code. AST-validated — rejects if the result has parse errors, so you can't accidentally break syntax. Use instead of manual text editing for function rewrites. Params: file (string), symbol (string), code (string) [, commit (bool)]
`lowercase-keywords`	Lowercase all SQL keywords
`move_symbol`	Move a function, class, or type to a different file and automatically update all imports across the codebase. Use instead of manually cut/paste + fixing imports. Works without LSP (single-file); LSP enables cross-file import updates. Params: file (string), symbol (string), destination (string) [, preview (bool), receipt (bool)]
`normalize-join-syntax`	Convert implicit JOIN (comma-separated tables) to explicit JOIN syntax
`normalize-null-handling`	Normalize IS NULL / IS NOT NULL
`recipe_run`	Run a codemod recipe: declarative match → transform → optional verify across modeled grammars. Preview lists matches; apply writes with optional E7 receipts and all-or-nothing rollback. Returns a per-site report.
`remove-duplicate-columns`	Remove duplicate columns from SELECT
`remove-redundant-where-conditions`	Remove redundant WHERE conditions
`remove-unnecessary-alias`	Remove unnecessary table aliases
`remove-unnecessary-distinct`	Remove unnecessary DISTINCT keyword
`remove-unnecessary-group-by`	Remove unnecessary GROUP BY clause
`rename`	Rename a symbol and automatically update ALL references across the codebase. Safer and faster than find-and-replace — AST-aware, won't rename strings or comments. Works without LSP (single-file); LSP enables cross-file renames. Params: file (string), old_name (string), new_name (string) [, line (u32), column (u32), preview (bool), receipt (bool)]
`rename-alias`	Rename a table/subquery alias and update references
`rename-column`	Rename a column and update references
`rename-table`	Rename a table and update all references
`simplify-boolean-expression`	Simplify boolean expressions
`uppercase-keywords`	Uppercase all SQL keywords

Analysis

42 analysis tools, the same on every supported language. Descriptions live in the shared reference: /docs/analysis-tools.

analyze_api_diff analyze_chokepoints analyze_clones analyze_clusters analyze_cohesion analyze_conformance analyze_coupling analyze_cycle_risk analyze_cycles analyze_dead_code analyze_depth analyze_entry_points analyze_export analyze_extraction analyze_fan_balance analyze_features analyze_hotspots analyze_impact analyze_inconsistencies analyze_inheritance analyze_interface_bloat analyze_interfaces analyze_layers analyze_orphan_types analyze_patterns analyze_platform_deps analyze_readiness analyze_roles analyze_seams analyze_stability analyze_surface analyze_test_gaps analyze_thickness analyze_type_completeness churn_hotspots co_change_clusters coverage_overlay ownership_map profile_overlay simulate split_module trace_overlay

Verify

14 verify tools, the same on every supported language. Descriptions live in the shared reference: /docs/verification.

bisect_regression gate generate_test_harness scan secret_surface summarize_pr taint_flow unsafe_surface verify_behavioral_equivalence verify_contract_preserved verify_diff_semantics verify_port_parity verify_side_effects verify_test_impact

← SOQLSQLite →