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

eva-qa-database

Query and manage the Eva QA database via PowerShell functions.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This skill provides access to the Eva QA database from PowerShell, enabling fast querying and basic data management in the QA environment.

Core Features & Use Cases

  • SELECT queries using Invoke-EvaSql to retrieve data from core Eva QA tables (e.g., sessions, CommitteeReports).
  • INSERT operations via Invoke-EvaSqlNonQuery to add new QA records safely.
  • Environment awareness with predefined environments (QA, DEMO, UAT, Local) and references to schema and common queries for quick lookups.
  • Real-world usage: fetch the current session, list recent committee reports, or insert a test session for validation.

Quick Start

Run a sample QA query to fetch the current session with Invoke-EvaSql.

Frequently Asked Questions about eva-qa-database

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

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

You can query the Eva QA database from PowerShell by running SELECT statements through the Invoke-EvaSql helper function to retrieve data from core tables like sessions and CommitteeReports.

What environments are supported for managing Eva database sessions?▼

Eva database management supports QA, DEMO, UAT, and Local environments, allowing you to target specific deployment stages for sessions, committee data, and meeting notices.

Can I insert test records into the Eva QA database via PowerShell?▼

Yes, you can safely insert new QA records by using the Invoke-EvaSqlNonQuery function, which is designed for executing INSERT operations without returning query data.

Do I need the EvaSql dependency to run database queries for Eva?▼

Yes, the EvaSql dependency is required as it provides the underlying Invoke-EvaSql and Invoke-EvaSqlNonQuery functions used to execute SQL queries and manage data.

What is the best way to retrieve recent committee reports from the Eva QA database?▼

The best way to retrieve recent committee reports is by executing a SELECT query using the Invoke-EvaSql function, referencing the core schema provided in the skill's documentation.

Are there limitations when using PowerShell to manage the Eva QA database?▼

This skill is designed for QA, DEMO, UAT, and Local environments and focuses on SELECT and INSERT helpers, meaning broader data management operations or production environments are not supported.

Related Skills

Explore More Data & Analytics Skills→
bigandslowbigandslow

Query Supabase Database

Execute PostgreSQL commands on Supabase databases using psql with 1Password credentials.

Community
Intermediate
promptrankspromptranks

prk-psv-export

Export validated PSV samples to SQL or JSON for database import.

Official
Intermediate
marcussheppmarcusshepp
3

legislature-qa-database

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

Community
Intermediate
xukrutdonutxukrutdonut

database

Execute SQL queries and manage schemas across PostgreSQL, MySQL, SQLite, MongoDB, and Redis.

Community
Intermediate