- Replace 'codebase' with 'search/codebase'
- Replace 'searchResults' with 'search/searchResults'
- Replace 'terminalLastCommand' with 'runCommands/terminalLastCommand'
- Replace 'terminalSelection' with 'runCommands/terminalSelection'
Updated files:
- 13 chatmode files in chatmodes/
- 41 prompt files in prompts/
This update aligns with VS Code's latest tool naming conventions that organize tools into logical namespaces.
* ms-sql-dba.chatmode
* update-readme.js changes
* more refining
* add instructions file
* adress missed changes and apply suggestions
* Add comprehensive SQL and PostgreSQL prompt collection
- Add sql-code-review.prompt.md: Universal SQL code review for security, maintainability, and quality standards
- Add sql-optimization.prompt.md: Universal SQL performance optimization for query tuning and indexing
- Add postgresql-code-review.prompt.md: PostgreSQL-specific code review focusing on PG best practices and anti-patterns
- Add postgresql-optimization.prompt.md: PostgreSQL-specific development assistant for unique PG features (JSONB, arrays, custom types)
This creates a complete 4-prompt ecosystem with zero overlap:
- Universal SQL (code quality + performance) for cross-database compatibility
- PostgreSQL-specific (code quality + performance) for PG-exclusive features
Each prompt serves distinct, isolated purposes while complementing each other for comprehensive SQL development support.
* enhance: Add comprehensive descriptions and model testing info
- Enhanced all 4 prompt descriptions with detailed capability coverage
- Added tested_with: 'GitHub Copilot Chat (GPT-4o)' to all prompts
- Specified database coverage (MySQL, PostgreSQL, SQL Server, Oracle)
- Detailed feature coverage for each prompt's unique capabilities
- Updated README.md with enhanced descriptions
Addresses PR review feedback for comprehensive descriptions and model testing specification.
* Enhance SQL and PostgreSQL prompts with comprehensive descriptions and testing validation
- Added detailed descriptions for all four prompts explaining their specific purposes
- Enhanced technical depth with comprehensive coverage areas
- Added testing validation with GitHub Copilot Chat (GPT-4o) - Validated July 20, 2025
- Improved frontmatter documentation for better discoverability
- Ensured zero functional overlap between Universal SQL and PostgreSQL-specific prompts
- Completed 4-prompt ecosystem: Code Quality Performance for both Universal SQL and PostgreSQL
---------
Co-authored-by: Aaron Powell <me@aaron-powell.com>
Co-authored-by: Matt Soucoup <masoucou@microsoft.com>
