Developer TMS Software has released a FireDAC-powered MCP server that lets AI agents explore, query, and optionally modify databases through natural-language conversations.
The server connects to any database supported by FireDAC using a single connection string. AI clients can inspect schemas, list tables, describe columns, generate SQL, run queries, and return strongly typed results as JSON. The same executable can work with SQLite, PostgreSQL, MySQL and MariaDB, SQL Server, Oracle, Firebird, InterBase, and ODBC data sources.
Access is controlled through three modes. The default readonly mode exposes only metadata and query tools. Readwrite adds data modification, while full also permits schema changes. In readonly mode, the mutation tool is not registered at all, preventing the AI from attempting database writes.
The server also includes SQL classification, parameter binding, row limits, password redaction, statement-stacking protection, and safeguards against commands that exceed the selected access mode. It can connect at startup or ask for the target database during the AI conversation.
Built with the TMS MCP SDK, the project provides a practical foundation for database assistants, reporting agents, administrative tools, and natural-language data exploration in Delphi.
Turn any FireDAC database into a guarded set of tools your AI agent can use.
