← SQL CopilotCONTENT HISTORY

Update to SQL Copilot

Snapshot Nov 4, 2026 · 00:11 UTC · version 0.2.0

Collection source: downloaded plugin package.

WHAT CHANGED

First saved snapshot

No earlier snapshot is available to establish a change.

Save SQL Copilot and check future changes in Following.

Up to 10 plugins free · no card required.

Compare saved observations

Download comparison JSON
Full technical diff · 0 changed fields
Full snapshot data
{
  "description": "Create reproducible SQL test fixtures, expected outputs and cross-engine equivalence checks.",
  "included_files": [],
  "name": "test-sql-logic",
  "skill_md_contents": "---\nname: test-sql-logic\ndescription: Create reproducible SQL test fixtures, expected outputs and cross-engine equivalence checks.\n---\n\n# Test Sql Logic\n\n**Trigger:** Create reproducible SQL test fixtures, expected outputs and cross-engine equivalence checks.\n\n## Workflow\n1. Identify query invariants and edge cases: missing keys, duplicates, NULL, zero rows, dates at boundaries, ties, skew and unexpected cardinality.\n2. Construct minimal sample rows with expected answers; use the target dialect when possible.\n3. Distinguish unit fixture tests from production-data verification and version-dependent optimizer checks.\n4. Run tests only if a SQL execution tool is available; otherwise give copyable setup/assertion SQL and mark unexecuted.\n5. Explain how to compare totals, unique keys, exact rows and numerical tolerance for precision differences.\n\n## Critical standard\nSQLite fixture results do not prove validity on Snowflake, BigQuery, Databricks or SQL Server.\n\n## Evidence and execution\nOnly say \"executed\", \"passed\", \"observed\", \"optimized\" or \"deployed\" when a connected tool returned evidence for that claim. An SQL draft, a textual review, or local fixture proof alone is not production validation. Never ask the user to paste passwords or raw confidential records.\n\n## Supporting references\n- Read `../../references/testing-method.md` when relevant.\n- Read `../../references/reconciliation.md` when relevant.\n\n## Return\nFixture DDL/rows, assertions, commands if run and evidence status.\n"
}

SHA-256 of public snapshot: 1818eb2616015abbe86a2ac611b6fe89ba48a707eb61368eb9b7305866c4ff87