legislature-qa-database

What problem does it solve?

Provide secure, scriptable access to the Legislature (M2) QA database from PowerShell, enabling users to run SELECT and INSERT operations against QA environments.

Core Features & Use Cases

• Read data from the M2 QA environments using Invoke-EvaSql for SELECT queries across M2-QA, M2-DEMO, M2-UAT, and M2-Local.
• Insert new records using Invoke-EvaSqlNonQuery with safety restrictions to prevent updates and deletes outside controlled scopes.
• Use case examples cover committees, committee meetings, bills, and legislators in QA environments.

Quick Start

Run a SELECT query against the M2-QA environment to fetch active committees.