vc-module-sql-queries

Author and manage reusable reports in the Virto Commerce SQL Queries module via its REST API. Use this skill when the user wants to CREATE, UPDATE, TEST/PREVIEW, search, or DELETE saved SQL query reports — i.e. report authoring and lifecycle management for an administrator. Triggers include: "create a report", "add a SQL query", "edit the report query", "test this query before saving", "add a parameter to the report", "list all reports", "delete a report". Requires sql-queries:create / :update / :delete / :read permissions. Do NOT use this skill for merely running an existing report to get data — that is vc-sql-queries-business. Do NOT use it to design schema-level changes to the platform database.

Run existing reports in the Virto Commerce SQL Queries module via its REST API and return or export the results. Use this skill when the user wants to GET DATA from a report that already exists — i.e. find a report, run it with parameter values, read the rows, and optionally export to CSV/XLSX/PDF/HTML. Triggers include: "run the X report", "what does the orders report show for last month", "export the report to Excel", "give me the numbers from <report>", "which reports can I run". Requires sql-queries:access and sql-queries:read. Do NOT use this skill to create, edit, or delete reports or to author SQL — that is vc-sql-queries-admin. This skill never writes SQL; it only runs reports an admin already saved.