MCP RifaExpress Backend
An MCP server designed to interact with the RifaExpress backend via PostgreSQL database queries and REST API integrations. It enables users to manage core entities like companies, users, and plans while providing tools for database schema inspection and health monitoring.
README
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 PostgreSQLrifaexpress_inspect_table- Ver schema de una tablarifaexpress_list_tables- Listar todas las tablas
Entidades
rifaexpress_get_companies- Obtener companies con filtrosrifaexpress_get_users- Obtener users con filtrosrifaexpress_get_plans- Obtener plansrifaexpress_get_subscriptions- Obtener subscriptions (cuando exista la tabla)
Utilidades
rifaexpress_health_check- Verificar conexión a BD y API
Recommended Servers
playwright-mcp
A Model Context Protocol server that enables LLMs to interact with web pages through structured accessibility snapshots without requiring vision models or screenshots.
Magic Component Platform (MCP)
An AI-powered tool that generates modern UI components from natural language descriptions, integrating with popular IDEs to streamline UI development workflow.
Audiense Insights MCP Server
Enables interaction with Audiense Insights accounts via the Model Context Protocol, facilitating the extraction and analysis of marketing insights and audience data including demographics, behavior, and influencer engagement.
VeyraX MCP
Single MCP tool to connect all your favorite tools: Gmail, Calendar and 40 more.
Kagi MCP Server
An MCP server that integrates Kagi search capabilities with Claude AI, enabling Claude to perform real-time web searches when answering questions that require up-to-date information.
graphlit-mcp-server
The Model Context Protocol (MCP) Server enables integration between MCP clients and the Graphlit service. Ingest anything from Slack to Gmail to podcast feeds, in addition to web crawling, into a Graphlit project - and then retrieve relevant contents from the MCP client.
Qdrant Server
This repository is an example of how to create a MCP server for Qdrant, a vector search engine.
Neon Database
MCP server for interacting with Neon Management API and databases
Exa Search
A Model Context Protocol (MCP) server lets AI assistants like Claude use the Exa AI Search API for web searches. This setup allows AI models to get real-time web information in a safe and controlled way.
E2B
Using MCP to run code via e2b.