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.

Worked SQL examples

act101 parses SQL with the tree-sitter grammar and edits SELECT lists, FROM/JOIN clauses, and table/column identifiers as syntax nodes, so an alias or renamed table lands on every place it belongs and nowhere else. It can append an AS alias to a column expression in the SELECT list. It can append an AS alias to a table in the FROM clause of a join. And it can rename a table identifier across FROM, WHERE, and every qualified column reference in the same query. Each example below is the verbatim output of the command shown, run against the file shown.

Alias a joined column

orders.sql selects o.total from a join between users and orders with no alias.

$ act refactor-lang add_column_alias --file orders.sql --params '{"column":"o.total","alias":"order_total","line":1,"symbol":""}'

Before

SELECT u.name, o.total
FROM users u
INNER JOIN orders o ON u.id = o.user_id;

After

SELECT u.name, o.total AS order_total
FROM users u
INNER JOIN orders o ON u.id = o.user_id;

o.total becomes o.total AS order_total; the rest of the query is unchanged.

Alias a table in a LEFT JOIN

joins.sql selects from users LEFT JOIN orders with users unaliased.

$ act refactor-lang add_table_alias --file joins.sql --params '{"line":1,"column":1}'

Before

SELECT * FROM users LEFT JOIN orders ON users.id = orders.user_id;

After

SELECT * FROM users AS t1 LEFT JOIN orders ON users.id = orders.user_id;

FROM users becomes FROM users AS t1; the join and its ON condition are unchanged.

Rename a table everywhere it appears

members.sql selects from users and also qualifies a column with users.active in the WHERE clause.

$ act refactor-lang rename_table --file members.sql --params '{"old_name":"users","new_name":"members","line":1,"column":1,"symbol":""}'

Before

SELECT name, email
FROM users
WHERE users.active = TRUE;

After

SELECT name, email
FROM members
WHERE members.active = TRUE;

Both the FROM users reference and the qualified users.active become members.

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

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