build-caldova-evidence-agent
Build, provision, repair, or verify the Caldova Evidence Agent stack. Use when: build the Caldova evidence agent, deploy the evidence demo, provision SQL MCP, create the hosted agent, publish the evidence skill, deploy the app, rebuild the demo, or verify the complete environment.
- License 许可
- MIT
- 最近更新
- 2026-11-01
- Stars
- ★ 3
- Forks
- 0
01 前言 Front Matter
- name
- build-caldova-evidence-agent
- description
- Build, provision, repair, or verify the Caldova Evidence Agent stack. Use when: build the Caldova evidence agent, deploy the evidence demo, provision SQL MCP, create the hosted agent, publish the evidence skill, deploy the app, rebuild the demo, or verify the complete environment.
03 SKILL.md 正文
Build Caldova Evidence Agent
Use the repository's staged scripts as the source of truth. Do not recreate resources with ad hoc commands when a canonical script exists.
Workflow
- Read
README.md, especially Prerequisites, Portable Configuration, and Security Boundary. - Establish fresh state with
az account show; do not infer subscription or deployment health from terminal history. - Confirm the target subscription, tenant, regions, resource group, and naming suffix from environment variables or the defaults resolved by
deploy/00-config.ps1. - Run
deploy/01-preflight.ps1synchronously. It is read-only. - Before creating billable resources, show the resolved target and ask for plain-text approval.
- For a complete build, run
deploy/Build-All.ps1synchronously with no timeout. - For repair, start at the earliest failed numbered stage and continue through
deploy/11-verify-system.ps1. - Report the App Service URL, hosted-agent version, skill version, SQL MCP endpoint, and verification results.
Guardrails
- Never run
azd ai agent init; the hosted project is already scaffolded. - Never copy
.env,.azure,.checkpoints,bin,obj,dist, ornode_modulesinto source control. - Treat
deploy/01-preflight.ps1as the subscription and quota gate. - Do not weaken the three-tool SQL MCP boundary.
- Do not expose secrets or access tokens in output.
- Do not delete or recreate the resource group unless explicitly requested.
04 同仓库更多 Skills
keynote-demo-app
Build or extend a SQLCon EU 2026 keynote demo application so it looks and behaves like the other keynote apps. Use when creating a new demo view (invoices, operations, orders), restyling an existing app to match, adding a deliberate database anti-pattern for a troubleshooting demo, or wiring an app to Azure SQL or Fabric SQL with managed identity. Triggers include "make this look like the keynote app", "build a demo view", "add the slow query demo", "match Caldova styling".
validate-post-migration-data
Validate data and schema after migrating SQL Server to Azure SQL Database, Azure SQL Managed Instance, or SQL Server on Azure VM. Use after migration, restore, BACPAC import, LRS completion, cutover validation, row-count comparison, or source-target reconciliation.
sql-server-to-sql-mi-lrs-migration
Migrate SQL Server databases to Azure SQL Managed Instance with Log Replay Service (LRS) using managed identity for Blob access. Use for SQL Server to SQL MI, LRS, log replay, continuous restore, or low-downtime backup-chain migrations.
sql-bacpac-to-azure-sql-db-migration
Migrate one or all user databases from SQL Server to Azure SQL Database with an offline BACPAC workflow. Use for BACPAC, SqlPackage export/import, bulk database migration, or offline Azure SQL Database migration requests.
sql-backup-restore-to-azure-sql-vm-migration
Migrate a SQL Server 2008 through SQL Server 2025 source to a SQL Server 2025 target wherever it runs, including SQL Server on Azure VM, by creating a local full backup, uploading it to Azure Blob Storage with AzCopy and the operator's Microsoft Entra identity, and restoring from URL with the target SQL Server managed identity. Sources newer than SQL Server 2025 are blocked because target restore compatibility has not been validated. Use for SQL-to-SQL, local-backup, AzCopy, managed-identity, Azure SQL VM, or SQL Server 2025 restore migrations.
run-migration-assessment
Route generic or unresolved SQL Server assessment, readiness, compatibility, cost, and SKU recommendation requests. Use for bare server names or whenever Azure versus local/on-premises is not explicit; ask which source applies, then delegate.