The Agent Skills Directory

[Environment and Tool Verification]: The skill provides instructions for the agent to verify the versions of installed development tools using commands like az version, dotnet --version, and sqlcmd --version. These are standard checks used to ensure the environment matches the expected configuration for Azure SQL Database development.
[Database Engine Identification]: It includes a T-SQL query to check SERVERPROPERTY('EngineEdition'). This allows the agent to programmatically confirm it is interacting with an Azure SQL Database instance rather than a sibling product like Managed Instance or SQL Server, ensuring that subsequent advice remains accurate and safe.
[Security Guidance and Best Practices]: The skill emphasizes critical security principles, including the use of managed identities to avoid hardcoding secrets, the enforcement of encryption, and the requirement for parameterizing all T-SQL statements to prevent injection vulnerabilities.
[Integration with Trusted Documentation]: The skill directs the agent to fetch information from official Microsoft Learn URLs. This approach ensures that information regarding service limits, feature availability, and preview status is retrieved from trusted, authoritative sources rather than relying on potentially outdated internal model data.
[Tool-Specific Verification]: The use of npx --yes prisma --version is included as a fallback to check the version of the Prisma CLI. While this involving fetching from the npm registry, it is a common practice in modern web and database development for tool verification.

azure-sql