メニュー
Query and analyze the Eva QA database using PowerShell functions. Use when working with Eva sessions, committee reports, meeting notices, or any Eva application data in the QA environment.
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
SOC 職業分類に基づく
Common patterns and workflows for Azure DevOps and database queries. Use to avoid inefficient searches and tangents.
Enables Copilot to SSH into the Fizz EC2 instance and manage Docker containers for the fyzz.dev production app.
Retrieve complete details for specific Azure DevOps work items by ID, including all fields, comments, change history, and related items. Use when the user asks about a specific ticket number or needs full context on a work item. PAT token in .env file at network/.env.
Search for Azure DevOps work items using text search and filters. Use when the user asks to find tickets, work items, issues, bugs, or user stories by keyword, state, assignment, tags, or area. PAT token in .env file at network/.env.
Navigate and understand the EvaAPI codebase structure. Use when searching for models, services, controllers, migrations, or any code related to Eva database entities. Helps locate where specific features are implemented.
Generate markdown reports of work items with optional details like acceptance criteria, descriptions, and comments. Use when creating sprint summaries, feature overviews, or documenting requirements.
| name | eva-qa-database |
| description | Query and analyze the Eva QA database using PowerShell functions. Use when working with Eva sessions, committee reports, meeting notices, or any Eva application data in the QA environment. |
| metadata | {"author":"michigan-senate","version":"1.0","environments":"QA, DEMO, UAT, Local"} |
This skill provides access to the Eva application database in the QA environment using PowerShell functions.
Use Invoke-EvaSql for SELECT queries that return data:
Invoke-EvaSql -Query "SELECT * FROM sessions" -Environment QA
Security Note: Invoke-EvaSql is restricted to SELECT queries only. UPDATE, DELETE, DROP, and other dangerous operations are blocked for safety.
Use Invoke-EvaSqlNonQuery for inserting new records:
Invoke-EvaSqlNonQuery -Query "INSERT INTO sessions (Name, StartDate) VALUES ('Test Session', GETDATE())" -Environment QA
Security Note: Invoke-EvaSqlNonQuery is restricted to INSERT queries only. UPDATE and DELETE operations are blocked to prevent accidental data modification.
QA (default) - Eva_QA database on tvmwsqls01DEMO - Eva_DEMO database on uvmwsqls01UAT - Eva_UAT database on uvmwsqls01Local - Local development databaseSee DATABASE-SCHEMA.md for complete schema information.
sessions - Legislative sessionsCommitteeReports - Committee report dataCommitteeMeetingNotices - Meeting noticesCommitteeMeetingAgendaData - Agenda itemsCalendarCommitteeEdits - Calendar editsSee COMMON-QUERIES.md for frequently used queries.
Invoke-EvaSql -Query "SELECT * FROM sessions WHERE IsCurrentSession = 1" -Environment QA
Invoke-EvaSql -Query "SELECT TOP 10 * FROM CommitteeReports ORDER BY Created DESC" -Environment QA
Invoke-EvaSql -Query "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE '%pattern%'" -Environment QA
Connection strings are managed in the EvaSql.psm1 module. See CONNECTION-STRINGS.md for details.
Error: "Invalid object name"
Error: "Invalid column name"
Connection timeout