◆ Technical section · The shift

AI, Ollama & MCP

Intelligence isn't an add-on: it's infrastructure. Embeddings run locally with Ollama, semantic search lives on PostgreSQL, and modules talk to models through MCP — the Model Context Protocol that exposes the platform as a set of safe tools.

0
Data sent out for embeddings
pgvector
Embeddings next to the data
MCP
Modules exposed as tools
How the AI layer is built
PostgreSQL + Ollama + MCP

The platform's data layer sits on PostgreSQL, with pgvector for embeddings next to the data. Semantic intelligence runs locally with Ollama; integration with models goes through a standard protocol, MCP. More control, data that stays in-house, and synchronization keeping the underlying operational systems aligned.

Data + vectors

PostgreSQL / pgvector

Identity, telemetry, documentation and embeddings in the same engine. Semantic search happens where the platform data already lives, with real referential integrity.

Local embeddings

Ollama

Embedding models run on the company server. Documents, notes and knowledge base become vectors without anything sensitive leaving the company perimeter.

AI bridge

MCP

Modules expose tools that models can invoke in a controlled way: list modules, search documents, scaffolding, archiving. Every call is explicit and traceable.

MCP at the center
The dtomes4-mcp server: the platform as tools

An MCP server (Node.js) operates on the whole project and exposes typed tools. It doesn't work "blind": it knows modules, forms, documents and registration rules. This is how AI acts on the platform with precision — both in development and at runtime. Generic AI starts from scratch; here it builds on a production-proven engine, on safe rails.

dtomes4-mcp

MCP server · stdio / HTTP · operates on the whole project

list_modulesDescribes modules and forms
search_documentsFull-text / semantic search
scaffold_moduleGenerates a new module
archive_documentArchives into MLPivot
describe_formStructure of a form
register_menuMenu entry registration
validate_moduleConsistency check
mlpp_importDocument import
Why it matters: with MCP, AI doesn't "guess" — it invokes real tools with clear contracts. This makes actions repeatable, verifiable and safe, and opens the door to assistants that operate inside the business software, not beside it. The same rules ensure every generated module (scaffold_module) inherits the central nervous system — dashboard (DAH), telemetry (SEH), audit, three-pillar documentation, MLPivot, log, Nginx and PostgreSQL synchronization — without writing them by hand. See the cross-cutting infrastructure →
Two ways to use it
In development and at runtime

🔧 AI-assisted development

AI accesses the sources and the MCP tools: it reads the .dpk files, understands conventions, proposes and generates coherent code, scaffolds new modules and verifies registration. An order of magnitude faster than traditional development.

scaffold_modulevalidate_moduleSkills

📊 AI features at runtime

The production dashboard integrates AI-assisted analysis. Semantic search over documents (Ollama embeddings + pgvector) powers contextual help and support. AI works on real data, traced via telemetry.

search_documentspgvectorMemoryLens
Security of the AI layer
Control, traceability, data in-house

🏠 Data stays local

Embeddings are generated by Ollama on the company server. No sensitive data leaves the perimeter to be vectorized.

🔑 Controlled access

The MCP server can run over stdio or HTTP with token and TLS. Tools have explicit contracts: you grant only what's needed.

📜 Everything traced

Actions go through telemetry on PostgreSQL: who, when, what. The same audit infrastructure as the platform.

AI as part of the system

PostgreSQL for data, Ollama for embeddings, MCP for tools. In-house, traced, repeatable.

← Architecture Let's talk ↑ Back to overview