mssql

What it does

This skill allows AI agents to execute read-only SQL queries against Microsoft SQL Server databases. It enables users to retrieve data and explore the structure of these databases without modifying any information. The agent can be used to run SELECT statements, view table schemas, and generally investigate database content.

When to use it

• Data Exploration: Quickly examine tables and columns within a SQL Server database to understand its contents.
• Schema Discovery: Determine the structure of databases, including available tables, views, and their respective columns.
• Reporting & Analysis: Extract specific data sets from MSSQL databases for reporting or further analysis in other tools.
• Ad-hoc Queries: Run simple SELECT queries to answer specific questions about the data stored within SQL Server instances.

Key capabilities

• Execute read-only SQL queries.
• Supports Microsoft SQL Server (MSSQL) and SQL Server databases.
• Limited to SELECT statements.

Example prompts

• "Show me all columns in the 'Customers' table."
• "Run a SELECT query: SELECT * FROM Products WHERE Price > 100;"
• "What tables exist in the database named 'SalesDB'?"

Tips & gotchas

• This skill is read-only; it cannot perform any data modification operations (e.g., INSERT, UPDATE, DELETE).
• Ensure you provide valid SQL syntax for queries to avoid errors.