database-queries

Name: database-queries
Availability: InStock
Author: MarketingLab

Provide SQL queries for debugging, monitoring, and data analysis across core database tables.

Updated Nov 6, 2025

Search Tags:#debugging #reports #database #queries #sql #data-analysis #membership-leads

Ready to run

npx skills add https://github.com/MarketingLabb/Coworkia-Agent --skill database-queries

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-queries
Source: https://github.com/MarketingLabb/Coworkia-Agent/tree/main/.github/skills/database-queries
Command: npx skills add https://github.com/MarketingLabb/Coworkia-Agent --skill database-queries

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Queries SQL comunes para debugging, monitoreo y análisis de datos. Usa este skill cuando necesites consultar reservas, leads, usuarios, follow-ups, verificar integridad de datos, generar reportes, o debuggear problemas de base de datos.

Core Features & Use Cases

Acceso y exploración de la base de datos con consultas de ejemplo para tablas clave (membership_leads, pending_confirmations, conversation_history).
Informes y auditoría: contar y validar estados, fechas y métricas relevantes para leads, reservas y usuarios.
Diagnóstico rápido: ejemplos de filtrado, agregaciones y validación de integridad para detectar anomalías.

Quick Start

Ejecuta una consulta de ejemplo para revisar la integridad de la base de datos.

Frequently Asked Questions about database-queries

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

FAQPage Schema

How do I run SQL queries to debug database tables like membership_leads?▼

To debug database tables like membership_leads, this Skill provides a curated set of SQL queries for quick diagnostic use. It allows you to inspect table structures, filter by status, and apply date-range queries to validate data integrity.

What SQL queries are needed for monitoring pending_confirmations data?▼

For monitoring pending_confirmations, you need SQL queries that count and validate states, dates, and relevant metrics. This Skill offers predefined queries to execute common health checks and detect anomalies in your reservation data.

Can I use these SQL queries for daily health checks and lead tracking?▼

Yes, you can use these SQL queries for daily health checks and lead tracking. The Skill applies to daily reporting scenarios, offering safe defaults for quick diagnostics across conversation history and membership leads.

Does this Skill support data analysis and report generation for conversation_history?▼

Yes, this Skill supports data analysis and report generation for conversation_history. It provides basic aggregates and filtering examples to validate relevant metrics and generate clear reports for your database.

What is the best way to inspect table structures and execute common queries?▼

The best way to inspect table structures and execute common queries is by using a curated set of predefined SQL statements. This Skill satisfies functional requirements for exploring core database tables and presenting safe defaults for quick diagnostics.