agentmods.dev

SQL-AI-samples: Instructions file for GitHub Copilot

AgentMode/.github/copilot-instructions.md

SQL-AI-samples copilot-instructions.md is an instructions file for GitHub Copilot from Azure-Samples/SQL-AI-samples. It costs 3,630 tokens per session, scanned A, original, MIT.

Instructions for building SQL database applications with SQL Database Projects, where database structure is stored as version-controlled SQL files. They cover organizing tables, views, and stored procedures and creating a local SQL Server instance.

In plain words
What is it for?
Use them to scaffold or modify a T-SQL application, organize database objects, keep scripts repeatable, and deploy a local SQL Server database.
Why use it?
They provide a consistent way to manage database changes and set up a local environment for development and testing.

Instructions file for GitHub Copilot

Written for GitHub Copilot: a Copilot instructions file.

This is Azure-Samples/SQL-AI-samples's own configuration. It tells GitHub Copilot how to work on SQL-AI-samples itself, so it is not a mod to install elsewhere. Copy it as a starting point and replace the rules that are about this project. Everything SQL-AI-samples configures →

not rated 331repo 5mo ago A scan 3,630 tokens original MIT
View source ↗ Azure-Samples/SQL-AI-samples aka.ms
Reuse

Borrowing it

Nothing to install: this file belongs to Azure-Samples/SQL-AI-samples. Take a copy, put it at the same path in your own repository, and replace the rules that are about this project with yours.

Copy the file
curl -O https://raw.githubusercontent.com/Azure-Samples/SQL-AI-samples/main/AgentMode/.github/copilot-instructions.md
Clone the repo
git clone --depth 1 https://github.com/Azure-Samples/SQL-AI-samples

Made for: GitHub Copilot.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for SQL-AI-samples copilot-instructions.md

README.md
[![agentmods](https://agentmods.dev/badge/instructions/azure-samples/sql-ai-samples/copilot-instructions/github.svg)](https://agentmods.dev/instructions/azure-samples/sql-ai-samples/copilot-instructions)
Your own site
<a href="https://agentmods.dev/instructions/azure-samples/sql-ai-samples/copilot-instructions"><img src="https://agentmods.dev/badge/instructions/azure-samples/sql-ai-samples/copilot-instructions/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for SQL-AI-samples copilot-instructions.md

Your own site · 80×15
<a href="https://agentmods.dev/instructions/azure-samples/sql-ai-samples/copilot-instructions"><img src="https://agentmods.dev/badge/instructions/azure-samples/sql-ai-samples/copilot-instructions.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 3,630 This file is loaded in full into every session.
When invoked 3,630 The same file — it is already loaded in full.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.03630 $0.03630
Opus 5.5 $0.01452 $0.01452
Sonnet 5.5 $0.00726 $0.00726
Haiku 4.5 $0.00363 $0.00363

Measured 2mo ago against content hash a973d950bf2b, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, from the pricing page.

Security

Grade A, and why

SQL-AI-samples copilot-instructions.md scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 2mo ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

AgentMode/.github/copilot-instructions.md · 278 lines

How it starts

The opening of the file, as written. The whole thing — 278 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Guidelines for AI Assistants: Scaffolding SQL Database Projects for T/SQL Applications

This notebook guides AI assistants through a step-by-step chain-of-thought to generate a full SQL Database Application using the SQL project SDK, Microsoft.Build.Sql

Each database object must be placed in its own .sql file, organized into a coherent folder structure. (this makes it easier for VSCode agent-mode to work with files)

The application should expose Stored Procedures and Views for all operations (all tables should be hidden as internal to the application).

NOTES:

  • You (the AI Agent) must not edit this file.

Summary

  • Use SQL Database Projects (.sqlproj) to manage schema as code. (Target SQL Server 2019, as this is the latest version that tSQLt supports via a .dacpac)
  • You can find the full documentation for Sql Database Projects here:
  • https://raw.githubusercontent.com/MicrosoftDocs/sql-docs/refs/heads/live/docs/tools/sql-database-projects/sql-database-projects.md
  • Keep T/SQL scripts idempotent and version-controlled.
  • For local deployment, use sqlcmd create mssql to create a local SQL Server instance.
  • use the helper script create-mssql-instance-using-sqlcmd.ps1 in the ./.github/tsql/install folder
  • To get the connection string, run sqlcmd config connection-strings (use the helper script get-sql-connection-string.ps1 in the ./.github/tsql/install folder).

Considerations

  • Folder structure maps directly to SQL object types.
  • Idempotency: scripts must handle repeated executions.
  • Naming conventions align with best practices.
  • After each step, you MUST:
    • build (using Build.ps1, which takes -ProjectName as the single parameter)
      • Build.ps1 is in the ./.github/tsql/inner-loop folder.
    • publish (using Publish.ps1, which takes -ProjectName as the single parameter)
      • Publish.ps1 is in the ./.github/tsql/inner-loop folder.
      • Publish.ps1 uses SqlPackage to publish the project to the SQL Server.

Read the full file on GitHub · 278 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 2mo ago First seen · 278 lines · 3,630 tokens per session scan A a973d950bf2b

Subscribe to this mod's changes

SQL-AI-samples copilot-instructions.md is an instructions file published in the GitHub repository Azure-Samples/SQL-AI-samples (331 stars, last pushed 5mo ago), licensed MIT. It adds 3,630 tokens to every session, about $0.0145 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

DatabasesLLMaiazureazure-sql-databaseazure-sql-db
Related

SQL-AI-samples copilot-instructions.md compared with instructions from other repositories

SQL-AI-samples copilot-instructions.md next to 6 instructions from other repositories
ModTypeStarsLast pushLicenceScanTokensWorks with
SQL-AI-samples copilot-instructions.mdAzure-Samples/SQL-AI-samplesInstructions file3315mo agoMITA3,630GitHub Copilot
vscode buildNext.instructions.mdmicrosoft/vscodeInstructions file195kyesterdayMITA9,719GitHub Copilot
next.js AGENTS.mdvercel/next.jsInstructions file143kyesterdayMITA7,461Codex, OpenCode
langchain AGENTS.mdlangchain-ai/langchainInstructions file149kyesterdayMITA4,680Codex, OpenCode
vscode oss-third-party-notices.instructions.mdmicrosoft/vscodeInstructions file195kyesterdayMITA5,516GitHub Copilot
vscode copilot-instructions.mdmicrosoft/vscodeInstructions file195kyesterdayMITA3,093GitHub Copilot
deepseek-harness AGENTS.mddeepseek-ai/deepseek-harnessInstructions file274k2d agoMITA4,313Codex, OpenCode