Which integrations are available for this server?

Provides tools to interact with a PostgreSQL database, allowing users to execute SELECT queries, inspect table schemas, and list available tables.

How do I use MCP RifaExpress Backend?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@MCP RifaExpress Backend show me the list of active users and their plans" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

MCP RifaExpress Backend

MCP Server para interactuar con el backend de RifaExpress (PostgreSQL + API REST).

Variables de Entorno

Crea un archivo .env en la raíz del proyecto:

# PostgreSQL Connection DB_HOST=localhost DB_PORT=5432 DB_NAME=rifaexpress DB_USER=postgres DB_PASSWORD=tu_password # API REST (opcional) API_URL=http://localhost:3000/api API_TOKEN=tu_jwt_token

Instalación

npm install npm run build

Uso

npm start

Tools Disponibles

Base de Datos

rifaexpress_query_db - Ejecutar queries SELECT en PostgreSQL
rifaexpress_inspect_table - Ver schema de una tabla
rifaexpress_list_tables - Listar todas las tablas

Entidades

rifaexpress_get_companies - Obtener companies con filtros
rifaexpress_get_users - Obtener users con filtros
rifaexpress_get_plans - Obtener plans
rifaexpress_get_subscriptions - Obtener subscriptions (cuando exista la tabla)