sarana-ai-eduall-mcp-server
by mejakitadev
Overview
A multi-component platform providing AI-powered omnichannel customer service, intelligent chat agents with knowledge base integration and tool use, OCR for document processing (KTP, STNK, BPKB, KK), analytics, and specialized data management for business operations (orders, support tickets, job vacancies) and agricultural intelligence (plantation data analysis and recommendations).
Installation
bash run.shEnvironment Variables
- PORT
- IS_DEBUG
- DB_CONNECTION_STRING
- REDIS_HOST
- REDIS_PORT
- REDIS_PASSWORD
- REDIS_DB
- REDIS_PREFIX
- RABBITMQ_HOST
- RABBITMQ_PORT
- RABBITMQ_USER
- RABBITMQ_PASS
- RABBITMQ_VIRTUAL_HOST
- OCR_ANALYSIS_QUEUE
- BUCKET_NAME
- FERNET_KEY
- GOOGLE_CLOUD_PROJECT
- VERTEX_AI_DEFAULT_REGION
- VERTEX_AI_DEFAULT_MODEL
- EMBEDDING_MODEL_NAME
- AGENT_TRANSFER_THRESHOLD_FAILURES
- AGENT_TRANSFER_THRESHOLD_FAILURE_SECONDS
- AGENT_TRANSFER_REDIS_TTL_HOURS
- WORKER_TYPE
Security Notes
The server generally uses SQLAlchemy ORM for database interactions, which protects against common SQL injection. However, 'api/archive/analytics.py' uses f-strings in SQL query construction for 'date_group', though currently mitigated by using a 'Literal' type. One hardcoded Google Cloud Storage bucket name ('bprks_sarana_temp') is present in 'api/archive/loan_origination.py'. File upload/decryption (`helper/encrypt.py`, `helper/cloud_storage.py`) and GCS interaction flows are implemented, requiring careful management of encryption keys and cloud storage permissions. Binding to '0.0.0.0' for uvicorn should be secured by external firewalling in production environments.
Similar Servers
redd-archiver
Archiving and providing AI-optimized access to Reddit-like platform data via a PostgreSQL-backed system and a RESTful API.
pluggedin-app
A testing environment for MCP (Model Control Protocol) servers, allowing interaction through a chat interface powered by LLMs and an AI agent using the LangChain ReAct framework.
supermcp
A multi-tenant SQL database connector for the MCP platform, enabling AI assistants to interact with various SQL databases like PostgreSQL, MySQL, MSSQL, Oracle, Snowflake, and SQLite through a unified interface.
agentxsuite
A unified open-source platform for connecting, managing, and monitoring AI agents and tools across various Model Context Protocol (MCP) servers.