- Add security warnings for credentials and TrustServerCertificate=yes
- Reference pyproject.toml for Python version requirements
- Remove duplicate team member table, add maintenance note
- Fix git add/stash guidance inconsistencies
- Clarify that TrustServerCertificate is for local dev only

- Add sequential prerequisite checks: venv → pytest → DB connection
- Ask user for connection string if not set (instead of offering unit tests only)
- Remove 'unit tests only' option
- Consolidate connection string setup in prerequisites section

- Check if venv is already active first
- Search for common venv directories (myvenv, venv, .venv, testenv)
- Offer to create new venv if none found

Renamed prompts to reflect natural workflow sequence:
- 01-setup-dev-env.prompt.md (first-time setup)
- 02-build-ddbc.prompt.md (build C++ extension)
- 03-run-tests.prompt.md (run pytest)
- 04-create-pr.prompt.md (submit work)

Updated all cross-references between prompts

…ools

- Added short names for easier invocation (/setup, /build, /test, /pr)
- Added descriptions for prompt picker
- Added argument hints to guide user input
- Set claude-sonnet-4 as preferred model
- Specified relevant tools for each prompt

- Remove argument-hint (prompts are interactive)
- Update tool names to new prefixed format (read/, search/, web/)
- Add github/* MCP server tools for PR creation
- Remove model field (use user's selected model)

Tools field was limiting agent capabilities. Removed to allow
full tool access based on VS Code settings.

…confusion

- Combine cd commands with build script to automatically return to root
- Update both macOS/Linux and Windows build commands
- Fix verification paths to assume repo root location
- Add note documenting the automatic directory return
- Prevents directory navigation issues during build verification

- All prompts now use numeric prefixes (01-04) for ordering
- Updated frontmatter with agent, description, and name fields
- Removed invalid/blocking fields (model, argument-hint, tools)
- Fixed tool references to use correct prefixes (read/, search/, web/)
- Build prompt enforces returning to repo root
- Test prompt has sequential prerequisites with proper venv checks

- setup -> mssql-python-setup
- build -> mssql-python-build
- test -> mssql-python-test
- pr -> mssql-python-pr

This provides better namespace clarity and avoids conflicts with other project prompts.

- Rename 01-setup-dev-env.prompt.md -> setup-dev-env.prompt.md
- Rename 02-build-ddbc.prompt.md -> build-ddbc.prompt.md
- Rename 03-run-tests.prompt.md -> run-tests.prompt.md
- Rename 04-create-pr.prompt.md -> create-pr.prompt.md

- Update all cross-references to use new names without numbers
- Improves discoverability and memorability of prompts
- Natural naming makes prompts easier to find via #mssql-python-*

…up prompts

- Add Step 4 in run-tests prompt to verify SQL Server is running before tests
- Run main.py to check connectivity and fail fast with helpful guidance
- Add comprehensive STEP 6 in setup-dev-env prompt for SQL Server setup
- Include Docker, native installation, and Azure SQL Database options
- Add detailed troubleshooting section with common issues and solutions
- Include connectivity testing with sqlcmd and Python
- Add debugging tools: port verification, log locations, network config
- Prevent wasted time on connection errors by validating environment first

- Remove Driver={ODBC Driver 18 for SQL Server} from all connection string examples
- Driver is reserved and automatically added by the driver
- Update format to use SERVER=, DATABASE=, UID=, PWD= keywords
- Add Encrypt=yes parameter for security
- Add clarifying notes about Driver being auto-added
- Addresses Saurabh's review comment on PR #393