Back to Home
white07S icon

important-mcp-server

Verified Safe

by white07S

Overview

This MCP server provides tools for semantic search over pre-indexed documents using Azure OpenAI embeddings and Qdrant, alongside robust PostgreSQL database health monitoring, query optimization, and index recommendations.

Installation

Run Command
uv run fastmcp run doc_mcp/server.py

Environment Variables

  • AZURE_OPENAI_ENDPOINT
  • AZURE_OPENAI_API_KEY
  • AZURE_OPENAI_API_VERSION
  • AZURE_OPENAI_EMBEDDING_DEPLOYMENT
  • DOC_MCP_QDRANT_HOST
  • DOC_MCP_QDRANT_PORT
  • DOC_MCP_COLLECTION
  • DOC_MCP_DEFAULT_TOPK
  • DOC_MCP_METADATA_PATHS
  • DATABASE_URI
  • POSTGRES_MCP_INCLUDE_LANGFUSE_TRACE

Security Notes

The PostgreSQL component (`postgres-mcp`) implements a `SafeSqlDriver` which uses `pglast` to parse and validate SQL queries, whitelisting allowed statement types (SELECT, ANALYZE, VACUUM, EXPLAIN, SHOW) and functions, providing strong protection against SQL injection and arbitrary DML/DDL operations when in 'restricted' access mode. It explicitly rejects `EXPLAIN ANALYZE` within `SafeSqlDriver` and prohibits locking clauses on `SELECT`. Secrets for Azure OpenAI and database connection strings are correctly handled via environment variables, not hardcoded. No `eval` or obfuscation detected. The primary security consideration is the broad power of SQL access if the server is run in 'unrestricted' mode, which is an explicit configuration choice.

Similar Servers

Stats

Interest Score0
Security Score9
Cost ClassMedium
Avg Tokens2500
Stars0
Forks0
Last Update2025-12-11

Tags

Semantic SearchDocument RetrievalQdrantAzure OpenAIPostgreSQLDatabase TuningQuery OptimizationAIAnalytics