Schema | MCP RifaExpress Backend

MCP RifaExpress Backend

Describes the environment variables required to run the server.

Name	Required	Description
`API_URL`	No	API REST URL (optional)
`DB_HOST`	Yes	PostgreSQL host
`DB_NAME`	Yes	PostgreSQL database name
`DB_PORT`	Yes	PostgreSQL port
`DB_USER`	Yes	PostgreSQL user
`API_TOKEN`	No	API REST JWT token (optional)
`DB_PASSWORD`	Yes	PostgreSQL password

Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.

This server publishes no instructions, or was last inspected before Glama recorded them.

Features and capabilities supported by this server

Protocol revision2025-11-25

Capability	Details
`tools`	{}

Functions exposed to the LLM to take actions

Name	Description
rifaexpress_query_dbA	Ejecuta una query SELECT en la base de datos PostgreSQL de RifaExpress. Solo queries SELECT están permitidas por seguridad.
rifaexpress_inspect_tableB	Inspecciona el schema de una tabla específica (columnas, tipos, nullability, etc.).
rifaexpress_list_tablesC	Lista todas las tablas en el schema especificado.
rifaexpress_get_companiesB	Obtiene companies (empresas) con filtros opcionales de subscriptionStatus.
rifaexpress_get_usersC	Obtiene users con filtros opcionales de companyId y role.
rifaexpress_get_plansC	Obtiene plans de suscripción.
rifaexpress_get_subscriptionsC	Obtiene subscriptions (si la tabla existe). Esta entidad se creará en Fase 1 del SaaS Core.
rifaexpress_health_checkA	Verifica la conexión con la base de datos PostgreSQL. Útil para diagnosticar problemas de configuración.

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
No resources

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/piedraprog/mcp_rifaexpress'

If you have feedback or need assistance with the MCP directory API, please join our Discord server