Schema

Schema

🚀 Value Proposition

Experience absolute confidence with our Enterprise-grade validation engine. We leverage Zod for robust, type-safe boundaries. We fully implement the Standard Schema specification. This guarantees seamless interoperability across modern AI frameworks. Ensure maximum reliability for all inputs. Eliminate hallucinations with our Dual-Schema Pattern. We deliver bulletproof validation and self-healing resilience.

Enforce Reliability: Enterprise Validation Rules

To provide a secure and robust integration experience, we strictly enforce the following schemas at the MCP boundary:

1. Strict Error Responses: All tools are guaranteed to return a structured error response upon failure. All errors extend MySQLMcpError (9 categories) and return enriched ErrorResponse via formatHandlerError(). Our resilient design ensures you will never encounter raw, unhandled exceptions, empowering self-healing autonomous workflows. The schema is: { success: false, error: string, code: string, category: string, suggestion: string, recoverable: boolean }
2. Deterministic Table Queries: Tools that query tables will return { exists: false, table: string } if the table does not exist, enabling graceful fallback handling in your LLM workflows.
3. Sandboxed File Operations: File system interactions are strictly bounded by ALLOWED_IO_ROOTS to prevent directory traversal and ensure isolated, secure execution.
4. Dual-Schema Pattern: Tools use a plain z.object() Base schema for MCP parameter visibility, and a z.preprocess() wrapper for handler parsing to support aliases and coercion without breaking standard JSON Schema generation.

Build with Confidence: Integration Guide

Please refer to the repository source for Zod schemas (src/adapters/mysql/schemas/). We highly recommend using schema.safeParse() when building custom MCP tool execution handlers or client integrations to handle validation errors gracefully without throwing exceptions.

For runtime schema introspection, see the Code Mode documentation, which allows you to programmatically discover API parameters and return types using the .schema() introspection method.