Blog

All Blog Posts | Next Post | Previous Post

Automate StellarDS database operations with AI via MCP

Thursday, October 23, 2025

The TMS AI Studio toolkit makes it easy to build, run, and integrate Model Context Protocol (MCP) servers — components that allow AI assistants to communicate directly with external data and services. Included with TMS AI Studio is a precompiled console application called the StellarDS MCP Server. This ready-to-run stdio server connects seamlessly to Stellards.io, a powerful Backend-as-a-Service (BaaS) platform, giving you instant access to cloud-hosted data through natural language. In this post, we’ll explain what the StellarDS MCP Server does, how it works internally, and how to run it.

TMS Software Delphi Components tmsaistudio

What the StellarDS MCP Server Does

The StellarDS MCP Server is a stdio-based MCP implementation created using TMS AI Studio’s MCP framework. It exposes your Stellards.io data to any AI assistant or client that supports the Model Context Protocol, such as Claude or ChatGPT.

With it, AI models can:

Query data from your Stellards.io projects
Create, update, and delete records
Modify database schemas (add fields, create tables, etc.)
Access project metadata — all via natural language

Instead of writing SQL or building API endpoints, you simply describe what you need, and the MCP server translates it into secure, structured operations.

Download the MCP Server!

How It Works

The precompiled server is a standard Delphi console application built with TMS AI Studio and the TMS.MCP.Attributes.Server unit. It uses the TTMSMCPAttributedServer class to expose MCP endpoints and the TTMSMCPStellarDS component to handle communication with Stellards.io. The application reads a Stellards.io access token from the command line and launches an MCP stdio server that interacts directly with your data.

Example Queries (from the AI side)

Once connected through an MCP-compatible AI client, you can issue natural-language requests such as:

“Show me all customers with active subscriptions.”

“Add a new record to the inventory table.”

“Delete all test entries older than 2023.”

“Create a new table named orders with fields id, email, and total_price.”

The StellarDS MCP Server converts these into secure API calls to Stellards.io and returns structured JSON responses.

Why Use the Precompiled Server

Zero setup: The server is included and ready to run — no compilation required.
MCP-compliant: Fully compatible with any MCP-aware AI model or system.
Extensible: Use it as a working reference when building your own MCP servers with TMS AI Studio.
Secure: Uses authenticated connections via Stellards.io API tokens.
Cross-platform: Works anywhere a stdio process can run.

Building Your Own MCP Servers

While the included StellarDS MCP Server is production-ready, TMS AI Studio allows you to create your own MCP servers in exactly the same way — using the MCP framework and your own data components.

You can easily define new MCP endpoints, connect to different services, or extend functionality using attributes and class bindings provided by the TMS.MCP.Attributes unit.

Conclusion

The StellarDS MCP Server included with TMS AI Studio is a powerful example of how simple it is to connect AI systems directly to real backend data. By pairing it with Stellards.io, you get a scalable, secure, and fully managed backend — instantly accessible through natural language and standard MCP communication.

To get started:

Install TMS AI Studio.
Connect it to your favorite AI assistant or MCP-compatible environment.
Prompt you AI for data

TMS AI Studio makes it easy to turn AI into a fully connected, data-aware development platform — starting with the precompiled StellarDS MCP Server.

Start Building the Future Today

The AI revolution is here, and with TMS AI Studio, Delphi developers are perfectly positioned to be at the forefront. Whether you're building intelligent business applications, creating AI-powered tools, or exploring the possibilities of the Model Context Protocol, TMS AI Studio gives you everything you need to succeed.

Ready to transform your development process?

Starting at 225 EUR for a single developer license, TMS AI Studio offers exceptional value for the comprehensive AI development toolkit it provides.

Get TMS AI Studio Now →

Join the growing community of developers who are already building tomorrow's AI applications with TMS AI Studio. The future of intelligent software development starts here.

TMS Software Delphi Components