database-data-management GitHub Copilot plugin guide

Q: How to install database-data-management in GitHub Copilot?

Run `copilot plugin install database-data-management@awesome-copilot` in your Copilot CLI.

Q: What extensions do the DBA agents require?

The `postgresql-dba` agent requires the PostgreSQL extension, while `ms-sql-dba` requires the MS SQL extension.

What database-data-management does

The plugin provides database tools directly in your editor. It focuses on execution plan analysis, query tuning, and code audits for MySQL, PostgreSQL, SQL Server, and Oracle.

Four slash commands and two agents handle the work. PostgreSQL-focused commands inspect JSONB queries and Row Level Security (RLS) rules. Two dedicated agents, postgresql-dba and ms-sql-dba, connect to databases using the PostgreSQL and MS SQL extensions.

Install this if you write raw SQL or manage database schemas manually. Projects that interact with databases only through basic ORM methods can skip it.

What it helps with

tune execution plans and pagination for heavy queries
audit database scripts for SQL injection risks
optimize PostgreSQL JSONB and array queries
configure Row Level Security policies in PostgreSQL schemas

Example prompts for the agent

/database-data-management:sql-optimization optimize pagination for this query
/database-data-management:postgresql-code-review check this table schema and RLS rules
@postgresql-dba analyze the execution plan for the orders query

How to install database-data-management

Command from the source

copilot plugin install database-data-management@awesome-copilot

From the same set554

The whole set →

git-commit official github This skill reviews Git changes, stages related files, and creates Conventional Commits. Use it when you want an agent to make one commit or split work into separate commits. GitHub Copilot 47,165installs excalidraw-diagram-generator official github Turn a plain-language description into an Excalidraw diagram. Useful for mapping processes, system structure, and relationships between entities. GitHub Copilot 31,639installs multi-stage-dockerfile official github This skill guides GitHub Copilot in writing multi-stage Dockerfiles for different languages and frameworks. Use it when the final runtime image should contain fewer build dependencies. GitHub Copilot 29,688installs documentation-writer official github Skill that turns the agent into a technical writer following the Diátaxis framework: tutorials, how-to guides, reference, and explanation. Proposes structure before writing. GitHub Copilot 27,757installs prd official github Turns a feature idea into a structured PRD with user stories, technical requirements, and risks. Use it when planning a software feature or an AI-powered one. GitHub Copilot 24,035installs refactor official github This skill reshapes existing code without changing its external behavior. Use it for gradual cleanup of large functions, duplication, weak types, and code smells. GitHub Copilot 22,321installs java-springboot official github Gives GitHub Copilot Spring Boot development practices, from project layout to tests and security. Use it when writing or reviewing Java application code. GitHub Copilot 21,272installs create-readme official github This skill reviews a project and creates a structured README.md. Use it when the repository needs clear documentation based on its actual files and code. GitHub Copilot 19,081installs

Questions about database-data-management

How to install database-data-management in GitHub Copilot?

Run copilot plugin install database-data-management@awesome-copilot in your Copilot CLI.

Which database engines are supported?

Universal commands support MySQL, PostgreSQL, SQL Server, and Oracle. Dedicated agents and deep feature checks focus specifically on PostgreSQL and Microsoft SQL Server.

What extensions do the DBA agents require?

The postgresql-dba agent requires the PostgreSQL extension, while ms-sql-dba requires the MS SQL extension.

Source text

database-data-management · MIT

# Database & Data Management Plugin

Database administration, SQL optimization, and data management tools for PostgreSQL, SQL Server, and general database development best practices.

## Installation

```bash
# Using Copilot CLI
copilot plugin install database-data-management@awesome-copilot
```

## What's Included

### Commands (Slash Commands)

| Command | Description |
|---------|-------------|
| `/database-data-management:sql-optimization` | Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Provides execution plan analysis, pagination optimization, batch operations, and performance monitoring guidance. |
| `/database-data-management:sql-code-review` | Universal SQL code review assistant that performs comprehensive security, maintainability, and code quality analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Focuses on SQL injection prevention, access control, code standards, and anti-pattern detection. Complements SQL optimization prompt for complete development coverage. |
| `/database-data-management:postgresql-optimization` | PostgreSQL-specific development assistant focusing on unique PostgreSQL features, advanced data types, and PostgreSQL-exclusive capabilities. Covers JSONB operations, array types, custom types, range/geometric types, full-text search, window functions, and PostgreSQL extensions ecosystem. |
| `/database-data-management:postgresql-code-review` | PostgreSQL-specific code review assistant focusing on PostgreSQL best practices, anti-patterns, and unique quality standards. Covers JSONB operations, array usage, custom types, schema design, function optimization, and PostgreSQL-exclusive security features like Row Level Security (RLS). |

### Agents

| Agent | Description |
|-------|-------------|
| `postgresql-dba` | Work with PostgreSQL databases using the PostgreSQL extension. |
| `ms-sql-dba` | Work with Microsoft SQL Server databases using the MS SQL extension. |

## Source

This plugin is part of [Awesome Copilot](https://github.com/github/awesome-copilot), a community-driven collection of GitHub Copilot extensions.

## License

MIT

database-data-management — GitHub Copilot plugin: what it does