skills.rest
marcusshepp
marcussheppCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

legislature-qa-database

Query and insert Legislature M2 QA database data via PowerShell functions.

3|Updated Feb 11, 2022
Search Tags:#database#qa#queries#sql#powershell#legislature#m2
One-click install
npx skills add https://github.com/marcusshepp/useful --skill legislature-qa-database
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: legislature-qa-database
Source: https://github.com/marcusshepp/useful/tree/main/network/.github/skills/legislature-qa-database
Command: npx skills add https://github.com/marcusshepp/useful --skill legislature-qa-database

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires EvaSql.psm1, and includes scripts (resource) and references (resource) components.

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.

Frequently Asked Questions about legislature-qa-database

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I query the Legislature M2 QA database using PowerShell?▼

You can query the Legislature M2 QA database using PowerShell by executing SELECT statements with the Invoke-EvaSql function across M2-QA, M2-DEMO, M2-UAT, and M2-Local environments.

Can I insert records into the M2 QA database with PowerShell?▼

Yes, you can insert new records into the M2 QA database using the Invoke-EvaSqlNonQuery PowerShell function, which enforces safety restrictions to prevent risky updates and deletes outside controlled scopes.

What legislative data can I retrieve from M2 QA environments?▼

You can retrieve legislative data including committees, committee meetings, bills, and legislators from the M2 QA environments using targeted SQL SELECT queries.

Does the Legislature QA database Skill support UPDATE or DELETE operations?▼

No, the Legislature QA database Skill enforces safety constraints by restricting risky SQL operations such as updates and deletes outside controlled scopes, limiting users to SELECT and INSERT actions.

What PowerShell module is required to run queries against the Legislature M2 database?▼

You need the EvaSql.psm1 PowerShell module installed to execute queries and insert data into the Legislature M2 QA database environments.

What's the best way to fetch active committees from the M2-QA environment?▼

The best way to fetch active committees from the M2-QA environment is running a SELECT query through the Invoke-EvaSql PowerShell function provided by the EvaSql.psm1 module.

Related Skills

Explore More Software Engineering Skills→
ortus-boxlangortus-boxlang

bx-jdbc

Select and install the correct BoxLang JDBC driver module for a database.

Official
Intermediate
dougdevitredougdevitre

mo-gov

Coordinate Missouri legislative outreach with lookups, letters, labels, and pipeline tracking.

Community
Advanced
nist0nist0

powershell

Automate PowerShell scripts with error handling, validation, and PSScriptAnalyzer linting.

Community
Advanced
HouseGarofaloHouseGarofalo
3

mssql-mcp

Query and manage Microsoft SQL Server and Azure SQL databases via MCP.

Official
Advanced