The KWDB MCP Server is a server implementation of the Model Context Protocol (MCP) that exposes tools and resources to interact with the KWDB database and enable business intelligence workflows through MCP. It supports reading, writing, querying, and modifying data, as well as performing DDL operations. The architecture includes components to parse MCP requests (StdIO or HTTP), schedule MCP Tools by operation type, automatically augment SQL with a LIMIT 20 clause for queries lacking a limit, and format all API responses in a consistent JSON structure. The server defines standard API responses: tool errors are wrapped in result objects with an isError flag; resources errors are returned as standard JSON-RPC errors; successful operations return content arrays or results. It enforces security by providing separate tools for read and write, validating queries against expected operation types, and printing clear error messages for unauthorized operations. MCP Resources expose read-only data such as product information, database metadata, and table schemas for MCP clients as context. MCP Tools expose executable functionality (e.g., read-query and write-query) to LLMs and external clients. Prompts, prompts.go, and embedded Markdown files define reusable templates and guides; three transport modes (StdIO, HTTP, SSE) enable flexible deployment, including LLM agent integration and troubleshooting.