postgres12-claude-mcp-server-usage
Verified Safeby povesma
Overview
This server tracks and logs usage data for a Multi-Cloud Platform (MCP) into a PostgreSQL database, utilizing Claude AI for potential analysis or processing of this usage data, and exposes this functionality via a RESTful API.
Installation
npm startEnvironment Variables
- PORT
- DATABASE_URL
- JWT_SECRET
- REDIS_URL
- ANTHROPIC_API_KEY
Security Notes
The code itself implements common security practices, including JWT for authentication, bcrypt for password hashing, parameterized queries to prevent SQL injection, and input validation with Yup. Sensitive configurations are correctly handled via environment variables. The overall security in production will depend on the secure management of these environment variables (e.g., JWT_SECRET, ANTHROPIC_API_KEY, DATABASE_URL) and proper CORS configuration.
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.
langgraph-dev-navigator
Provides a RAG and Knowledge Graph powered backend for grounding AI coding assistants in the LangGraph ecosystem, improving code generation accuracy and reducing hallucinations.
osmmcp
Enables LLMs to interact with OpenStreetMap data through a rich set of geospatial tools, including geocoding, routing, and points of interest search.
mcp-server
This server integrates Kontent.ai content management with AI tools, allowing natural language operations to create, manage, and explore structured content.