fintra-mcp-server
by RahulM0912
Overview
Provides an interface for an AI agent to interact with a PostgreSQL database, specifically for financial transaction management, by exposing tools for database schema description and SQL query execution.
Installation
npm startEnvironment Variables
- DATABASE_URL
- SUPABASE_URL
- SUPABASE_SERVICE_ROLE_KEY
Security Notes
CRITICAL: The `getQueryTool` in `src/controllers/tools.ts` directly executes arbitrary SQL queries provided as input (`pool.query(arg.sql)`). This design introduces a severe SQL injection vulnerability if the input `arg.sql` originates from untrusted user input without robust sanitization or proper parameterization. An attacker could exploit this to perform unauthorized data access, modification, deletion, or even full database compromise.
Similar Servers
MCP-PostgreSQL-Ops
The MCP server provides professional operations, monitoring, and management capabilities for PostgreSQL databases using natural language queries.
enhanced-postgres-mcp-server
This server acts as a Model Context Protocol interface for PostgreSQL, enabling LLMs to query data, modify records, and manage database schema objects with read and write capabilities.
mysql_mcp_server
This server provides a Model Context Protocol (MCP) interface to a MySQL database, enabling AI models to execute SQL queries and retrieve database schema information.
mcp-server
This server provides a Model Context Protocol (MCP) interface to a PostgreSQL database, allowing clients (e.g., AI models) to query the database and retrieve table schemas via defined tools.