Mccs

List Tables

List all user tables (excluding system tables) in the specified MCCS database. Use database="bank" for db_mccs_bank (transactions, payments, financial data) or database="panel" for db_mccs_panel (events, machotes, sales templates, panel config). IMPORTANT: table names are case-sensitive PascalCase (Prisma convention, e.g., "Event", "CourseTemplate", "MachoteCandidate") and MUST be wrapped in double quotes when used in raw SQL — `FROM event` will fail with 'relation does not exist'.

Describe Table

Get detailed column definitions, data types, constraints, and indexes for a specific table. Useful for understanding the schema before writing queries.

Query Bank DB

Execute a read-only SQL query against db_mccs_bank. This database contains financial/transactional data: payments, invoices, bank integrations (e.g., Banorte API data). Only SELECT and WITH (CTE) statements are allowed. Results are limited to 500 rows. CRITICAL: table and column names are PascalCase (Prisma convention) and case-sensitive in PostgreSQL. You MUST wrap them in double quotes: `SELECT * FROM "Payment" WHERE "userId" = $1` — unquoted names like `FROM payment` will fail.

Query Panel DB

Execute a read-only SQL query against db_mccs_panel. Main tables: "CourseTemplate" (catalog: courseSlug, titleBase, salesScript, price), "Event" (dates: courseSlug, eventDate, stock, price), "MachoteCandidate" (legacy templates). Only SELECT and WITH (CTE) statements are allowed. Results are limited to 500 rows. CRITICAL: table and column names are PascalCase (Prisma convention) and case-sensitive in PostgreSQL. You MUST wrap them in double quotes: `SELECT * FROM "Event" WHERE "courseSlug" = $1`

Query Both DBs

Execute read-only queries against BOTH db_mccs_bank and db_mccs_panel simultaneously. Useful for cross-referencing financial data with event/sales data. Each query runs independently and results are returned together for correlation. CRITICAL: table and column names are PascalCase (Prisma convention) and case-sensitive — wrap them in double quotes: `SELECT * FROM "Event"` (NOT `FROM event`).

Schema Overview

Get a high-level overview of BOTH MCCS databases: table names, row counts, and sizes. Use this as a starting point to understand the data model before diving into specific tables.

Search Events

Search for events, courses, or sales templates (machotes) in db_mccs_panel using fuzzy text matching. Designed for chatbot/end-user queries like '¿Hay lugar en el curso de cocina?' or 'Cuánto cuesta el taller de árabe?'. Searches across the rawTitle field in MachoteCandidate using case-insensitive, accent-insensitive, and partial matching (trigram similarity). Returns the top matches with all available details.

Get Sales Script

Busca en CourseTemplate (catálogo maestro de cursos/talleres) por nombre y devuelve el guion de ventas, precio y descripción. Diseñado para el chatbot: dado un término natural ('sushi', 'cocina saludable'), encuentra el courseSlug más relevante. Solo devuelve cursos con active = true. Usa similarity (pg_trgm) si está disponible, fallback a ILIKE.

Get Available Dates

Devuelve las fechas futuras con cupo disponible para un curso, identificado por courseSlug. Busca en la tabla Event con eventDate > NOW() y stock > 0. Convierte eventDate de UTC a America/Monterrey para hora local. Diseñado para el chatbot: encadenar después de get_sales_script.