pfn-mcp
Verified Safeby octbramantya
Overview
A conversational AI interface for industrial energy monitoring, analysis, and cost management using natural language queries against a PostgreSQL/TimescaleDB database.
Installation
pfn-chatEnvironment Variables
- DATABASE_URL
- ANTHROPIC_API_KEY
- KEYCLOAK_URL
- KEYCLOAK_REALM
- KEYCLOAK_CLIENT_ID
- KEYCLOAK_CLIENT_SECRET
- JWT_SECRET
- BUDGET_MONTHLY_USD
Security Notes
The project demonstrates strong security practices with parameterized SQL queries preventing injection and robust Keycloak OAuth/JWT authentication for access control. Critical internal servers (e.g., SSE transport for the MCP protocol) are explicitly warned against public internet exposure in the source code. Custom formula parsing includes robust validation to prevent injection. Hardcoded secrets are avoided, relying on environment variables. The primary security consideration is ensuring proper deployment (e.g., internal network access only for certain services) and strong environment variable management.
Similar Servers
pg-aiguide
Provides AI-optimized PostgreSQL expertise, including semantic search over documentation and curated best practices, to assist AI coding tools in generating better PostgreSQL code.
mcp-server-neon
The Neon MCP Server allows users to interact with and manage their Neon Postgres databases using natural language commands, acting as a bridge between AI agents/LLMs and the Neon API and database operations.
MCP-PostgreSQL-Ops
The MCP server provides professional operations, monitoring, and management capabilities for PostgreSQL databases using natural language queries.
DBchat
Transforms a database into an intelligent conversational partner, enabling natural language queries, instant answers, and data visualizations via MCP clients.