Skip to content

slash-commands.md

Latest commit

 

History

History
188 lines (130 loc) · 9.63 KB

slash-commands.md

File metadata and controls

188 lines (130 loc) · 9.63 KB
title Quickstart: Use GitHub Copilot Slash Commands
titleSuffix MSSQL Extension for Visual Studio Code
description Learn how to use GitHub Copilot slash commands with the MSSQL extension to manage connections, explore schemas, and run SQL queries directly in the GitHub Copilot chat in Visual Studio Code.
author croblesm
ms.author roblescarlos
ms.reviewer randolphwest
ms.date 01/19/2026
ms.service sql
ms.subservice vs-code-sql-extensions
ms.topic quickstart
ms.collection
data-tools
ce-skilling-ai-copilot
ms.custom
ignite-2025
ai-usage ai-assisted

Quickstart: Use GitHub Copilot slash commands

GitHub Copilot slash commands provide a quick, discoverable way to interact with your SQL Server databases directly from the GitHub Copilot chat in Visual Studio Code. You can access these commands through the MSSQL extension's integration with GitHub Copilot, using the @mssql chat participant. By typing / in the chat input, you can see a list of supported commands that accelerate common workflows like connecting, switching databases, exploring schemas, and running queries.

What are slash commands?

Slash commands provide a quick way to insert structured prompts directly into the GitHub Copilot chat. They're designed for speed and discoverability, helping you perform common database tasks without writing full natural language queries.

For example, you can type:

@mssql /getConnectionDetails

:::image type="content" source="media/slash-commands/slash-commands-chat.png" alt-text="Screenshot of using a slash command example in GitHub Copilot chat.":::

Note

Unlike Agent Mode tools, slash commands act as shortcuts: they insert structured prompts into the chat so you don't need to craft full natural language queries. Some commands run instantly (like switching databases), while others require follow-up input (like running or explaining a query).

MSSQL slash commands reference

This section provides a detailed reference for the SQL-specific slash commands available in GitHub Copilot. The MSSQL chat participant provides these commands, and you use them directly in the GitHub Copilot chat interface.

Important

All slash commands require an active editor connected to a database in order to work. If no connection is active, the commands don't execute.

:::image type="content" source="media/slash-commands/slash-command-options-1.png" alt-text="Screenshot of the first set of slash command options from the MSSQL extension in GitHub Copilot chat.":::

:::image type="content" source="media/slash-commands/slash-command-options-2.png" alt-text="Screenshot of the second set of slash command options from the MSSQL extension in GitHub Copilot chat.":::

Connection management

These commands let you establish, switch, or inspect connections. They don't require extra input: selecting one opens the connection panel or performs the action directly.

Command Description
/connect Opens the connection panel to establish a new database connection.
/disconnect Terminates the current active connection session.
/changeDatabase Opens the connection panel to switch to a different database in the current server.
/getConnectionDetails Displays details of the current connection, such as server, database, and authentication type.

Examples

Use the following phrases to interact with GitHub Copilot.

@mssql /connect
@mssql /disconnect
@mssql /changeDatabase
@mssql /getConnectionDetails

Here's how these commands look in action, to get connection details:

:::image type="content" source="media/slash-commands/slash-commands-chat.png" alt-text="Screenshot of using a slash command example in GitHub Copilot chat.":::

How connection logic works

Slash commands for connection management act as true shortcuts. Unlike Agent Mode tools that attempt to resolve connections automatically, these commands open the MSSQL extension connection dialog inside Visual Studio Code. You must interact with the dialog to select or create a connection.

When you invoke /connect or /changeDatabase:

  1. GitHub Copilot inserts the command into chat.
  2. The MSSQL extension opens the standard connection dialog.
  3. You choose an existing profile or create a new one.
  4. Once confirmed, the connection is established or switched.

When you invoke /disconnect:

  • The MSSQL extension terminates the active session immediately.

When you invoke /getConnectionDetails:

  • The MSSQL extension uses the current connection details in the chat, without requiring further input.

Here's how these commands look in action, to connect, or change databases:

:::image type="content" source="media/slash-commands/slash-command-change-database.gif" alt-text="Screenshot of animation showing the /changeDatabase slash command to switch databases from the chat interface." lightbox="media/slash-commands/slash-command-change-database.gif":::

This design keeps the experience consistent with the MSSQL extension UI: the slash command accelerates access, while the dialog ensures you can review and confirm connection details interactively.

Query execution and performance

These commands require follow-up input. After selecting a command, provide the SQL statement or object you want to analyze.

Command Description
/runQuery Runs a SQL query against the connected database and shows results in chat.
/explain Provides a natural-language explanation of SQL code or queries.
/fix Detects and corrects syntax issues or missing constraints in SQL code.
/optimize Analyzes query performance and suggests improvements (indexing, restructuring).

Examples

Use the following phrases to interact with GitHub Copilot.

@mssql /runQuery SELECT TOP 10 * FROM Orders
@mssql /explain SELECT COUNT(*) FROM Customers
@mssql /fix any errors in my query: SELECT * FROM Orders WHERE OrderDate > '2025-01-01'
@mssql /optimize SELECT * FROM Products WHERE Price > 100

Here's how these commands look in action, to run or optimize a query:

:::image type="content" source="media/slash-commands/slash-commands-run-query-1.png" alt-text="Screenshot showing the /runQuery slash command with SQL for top powerful Pokémon.":::

:::image type="content" source="media/slash-commands/slash-commands-run-query-2.png" alt-text="Screenshot showing the /runQuery slash command results for top powerful Pokémon.":::

:::image type="content" source="media/slash-commands/slash-commands-optimize-query-1.png" alt-text="Screenshot showing the /optimize slash command suggestion for a sargable query.":::

:::image type="content" source="media/slash-commands/slash-commands-optimize-query-2.png" alt-text="Screenshot showing the /optimize slash command detailed optimization suggestions and index creation.":::

Schema exploration and object management

These commands list or visualize schema objects in the connected database.

Command Description
/showSchema Displays a high-level diagram of the database schema, including tables, relationships, and keys.
/showDefinition Shows the definition of a specific table, view, function, or procedure.
/listServers Lists all saved SQL Server connection profiles.
/listDatabases Lists all databases on the current server.
/listSchemas Lists all schemas in the current database.
/listTables Lists all tables in the current database.
/listViews Lists all views in the current database.
/listFunctions Lists all functions in the current database.
/listProcedures Lists all stored procedures in the current database.

Examples

Use the following phrases to interact with GitHub Copilot.

@mssql /showSchema
@mssql /showDefinition Orders
@mssql /listDatabases
@mssql /listTables
@mssql /listViews
@mssql /listProcedures

Here's how these commands look in action, to explore schemas and list objects:

:::image type="content" source="media/slash-commands/slash-commands-list-schemas.png" alt-text="Screenshot of using the /listSchemas slash command in GitHub Copilot chat.":::

:::image type="content" source="media/slash-commands/slash-commands-list-tables.png" alt-text="Screenshot of using the /listTables slash command in GitHub Copilot chat.":::

Key differences from Agent Mode

  • Slash Commands: Insert structured prompts into the chat. Some commands act immediately, like connection management, while others require user input. They're designed for quick access and discoverability.

  • Agent Mode: Uses extension-contributed tools that execute actions directly, with confirmation dialogs for secure execution. Agent Mode supports richer, more complex workflows inside your SQL development environment.

You can use both approaches together. Slash commands speed up prompt entry, and Agent Mode executes secure, confirmable actions.

Related content