MCP RifaExpress Backend
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| 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 |
Capabilities
Features and capabilities supported by this server
| Capability | Details |
|---|---|
| tools | {} |
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. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Latest Blog Posts
MCP directory API
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