메뉴
Query and analyze the Legislature (M2) QA database using PowerShell functions. Use when working with committees, committee meetings, bills, legislators, or any Legislature/M2 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.
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.
| name | legislature-qa-database |
| description | Query and analyze the Legislature (M2) QA database using PowerShell functions. Use when working with committees, committee meetings, bills, legislators, or any Legislature/M2 application data in the QA environment. |
| metadata | {"author":"michigan-senate","version":"1.0","environments":"M2-QA, M2-DEMO, M2-UAT, M2-Local"} |
This skill provides access to the Legislature database (also called M2) in the QA environment using PowerShell functions.
Use Invoke-EvaSql with M2 environments for SELECT queries:
Invoke-EvaSql -Query "SELECT * FROM Committee" -Environment M2-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 Committee (CommitteeName, SessionID) VALUES ('Test Committee', 16)" -Environment M2-QA
Security Note: Invoke-EvaSqlNonQuery is restricted to INSERT queries only. UPDATE and DELETE operations are blocked to prevent accidental data modification.
M2-QA - Legislature database on tvmwsqls01 (most common)M2-DEMO - Legislature database on MLSQL-QA.lsb.legislature.mi.govM2-UAT - Legislature database on MLSQL-SUP.lsb.legislature.mi.govM2-Local - Local development Legislature databaseSee DATABASE-SCHEMA.md for complete schema information.
Committee - Committee definitionsCommitteeMeeting - Committee meeting recordsCommitteeMember - Committee membershipCommitteeMeetingAgendaItem - Agenda itemsCommitteeMeetingAttendanceRecord - Attendance trackingCommitteeRole - Committee role definitionsCommitteeType - Committee type classificationsSee COMMON-QUERIES.md for frequently used queries.
Invoke-EvaSql -Query "SELECT CommitteeID, CommitteeName, SessionID FROM Committee WHERE IsActive = 1" -Environment M2-QA
Invoke-EvaSql -Query "SELECT TOP 1 * FROM Committee ORDER BY CommitteeID DESC" -Environment M2-QA
Invoke-EvaSql -Query "SELECT * FROM Committee WHERE CommitteeName LIKE '%Finance%'" -Environment M2-QA
Connection strings are managed in the EvaSql.psm1 module. See CONNECTION-STRINGS.md for details.
Error: "Invalid object name 'Committees'"
Committee not CommitteesError: "Invalid column name 'Name'"
CommitteeName not NameError: "Invalid column name 'CreatedDate'"
DateAdded not CreatedDate