Elysia Tools
Navigation
Workflow Playbook
Build, format, and review SQL with join logic, performance evidence, explain plans, injection checks, foreign-key validation, and schema drift review.
Hubs
A readable query is only the first gate. A reliable review also needs to explain which tables are involved, why each join is correct, how parameters are bound, and whether the current schema can support the expected result.
Start with sql-query-builder and multi-table-joiner when the query is being assembled or translated from requirements. Then use sql-query-formatter and sql-formatter to make clauses, aliases, predicates, and diffs easy to review.
Next, use sql-performance-analyzer and sql-explain-plan-visualizer to inspect scans, sort operations, join order, and index assumptions. This matters most for SQL used by production API endpoints, dashboards, scheduled jobs, or shared analytics models.
sql-injection-detector helps catch unsafe interpolation or weak parameter handling before code review closes. data-foreign-key-validator, database-schema-diff, and table-schema-generator then verify that relationship logic and table assumptions match reality. A strong approval record names the database engine, reviewed plan, unresolved limits, and final decision: accept, revise, or block.
Workflow playbook
Build or reconstruct the SQL from target tables and join rules so reviewers can see the intended business logic.
Format the query consistently, align clauses and aliases, and make later diffs easier to inspect.
Analyze scan patterns, joins, sorts, and estimated costs, then visualize the explain plan before accepting an optimization.
Scan parameter usage for injection risk, validate foreign-key relationships, and compare schema assumptions with the current structure.
Use the builder and joiner when the query is still being assembled; start with formatting when an existing statement needs readable review evidence.
Performance and explain-plan review expose runtime risk, injection checks expose unsafe parameter handling, and foreign-key plus schema review protects relational correctness.