Architecture

Architecture

💎 Value Proposition

• Execute complex logic via Code Mode, reducing token usage by 70-90%.
• Build AI integrations instantly.
• Empower agents with secure database access.
• Scale operations with robust connection pooling.
• Leverage OAuth 2.1 for enterprise security.

Unlock Core Capabilities

• 200+ Specialized Tools distributed across 28 Tool Groups to handle everything from CRUD to Spatial analysis.
• 16 Shortcuts (Tool Filtering) to easily configure context-friendly setups.
• Observability Resources and AI-Powered Prompts to empower proactive agent workflows.

Scale Infrastructure Seamlessly

• Code Mode Execution: An isolated-vm sandbox reduces token overhead. This delivers massive cost savings. It includes configurable payload caps and rate limiting.
• Supported Transports: Seamlessly switch between stdio, http (Streamable HTTP /mcp), and sse (Legacy /sse).
• Authentication: We support Simple Bearer Tokens or full OAuth 2.1 (RFC 9728/8414) via Keycloak.

Review Recent Enhancements

• fix(security): allow mask data alias validation at MCP boundary.
• docs(tests): strengthen anti-hallucination guardrails across coordinator workflows (list_dir requirements, task.md checklist).
• fix(core): add conditional update aliases for data and conditions.
• fix(security): require at least one filter for audit tool to prevent payload bloat.
• fix(optimization): allow database-wide index audit in indexRecommendation by removing empty payload validation.
• test(http): streamable and http transport tests added.

Enforce Robust Security

• Dual-Schema Validation Pattern: Tools use a Base schema for visibility. They use a Derived schema for parsing. This supports aliases without breaking JSON Schema. Integrates Standard Schema interfaces via Zod's safe parsing patterns to strictly enforce tool boundaries. This robustly rejects invalid or hallucinated payloads at the MCP boundary, ensuring predictable AI agent execution.