skills.rest
MarketingLabb
MarketingLabbCOMMUNITY
Explore all skills by this author →
GitHub

database-queries

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
One-click install
npx skills add https://github.com/MarketingLabb/Coworkia-Agent --skill database-queries
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
Dhavanesh24cs412Dhavanesh24cs412
1

supabase-automation

Automate Supabase database queries, table management, and SQL execution via Rube MCP.

Community
Advanced
cyyehcyyeh
1

data-validation

Validate data analyses for methodological errors, bias, and reproducibility gaps.

Community
Intermediate
abzhawabzhaw

data-visualization

Render real-time charts of agent activity and data trends on Julia's dashboard.

Community
Intermediate
adryanmoldokkr32-pixeladryanmoldokkr32-pixel

canary

Monitor live applications for post-deploy errors, latency spikes, and page failures.

Community
Advanced