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)