Domain-Oriented Tooling for Model Context Protocols: Replacing Generic Query Interfaces with Declarative Abstractions

As Large Language Model (LLM) agents are increasingly integrated with enterprise data stores via the Model Context Protocol (MCP), a prevalent architectural anti-pattern has emerged: exposing generic database query interfaces (e.g., `execute_sql()` or `query_database()`). While versatile in experimental environments, this paradigm introduces operational friction, including high token consumption, non-deterministic query generation, business logic drift, and heightened security risks. This paper formalizes the Domain-Oriented Tooling Pattern, an architectural approach that abstracts relational databases behind a curated set of deterministic, domain-specific tools. We introduce MCP Blueprint, an open-source, configuration-driven framework that decouples tool metadata and SQL execution from application code. We discuss how domain-oriented tool abstractions lower the cognitive threshold required from the orchestrating model—enabling small, lightweight language models (SLMs) to serve the majority of enterprise data retrieval needs—while enforcing business logic determinism and reducing query execution risks.

Authors

Publication Details

Journal
Zenodo (CERN European Organization for Nuclear Research)
Published
2026-08-20
DOI
https://doi.org/10.5281/zenodo.22035893
Primary Topic
Business Process Modeling and Analysis
Type
preprint
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
preprint

Domain-Oriented Tooling for Model Context Protocols: Replacing Generic Query Interfaces with Declarative Abstractions

Bartolomeo Bogliolo
Zenodo (CERN European Organization for Nuclear Research)
Business Process Modeling and Analysis
preprint

Domain-Oriented Tooling for Model Context Protocols: Replacing Generic Query Interfaces with Declarative Abstractions

Bartolomeo Bogliolo
preprint en

Abstract

As Large Language Model (LLM) agents are increasingly integrated with enterprise data stores via the Model Context Protocol (MCP), a prevalent architectural anti-pattern has emerged: exposing generic database query interfaces (e.g., `execute_sql()` or `query_database()`). While versatile in experimental environments, this paradigm introduces operational friction, including high token consumption, non-deterministic query generation, business logic drift, and heightened security risks. This paper formalizes the Domain-Oriented Tooling Pattern, an architectural approach that abstracts relational databases behind a curated set of deterministic, domain-specific tools. We introduce MCP Blueprint, an open-source, configuration-driven framework that decouples tool metadata and SQL execution from application code. We discuss how domain-oriented tool abstractions lower the cognitive threshold required from the orchestrating model—enabling small, lightweight language models (SLMs) to serve the majority of enterprise data retrieval needs—while enforcing business logic determinism and reducing query execution risks.

Zenodo (CERN European Organization for Nuclear Research)
Business Process Modeling and Analysis
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.

Domain-Oriented Tooling for Model Context Protocols: Replacing Generic Query Interfaces with Declarative Abstractions — Bartolomeo Bogliolo · Zenodo (CERN European Organization for Nuclear Research) (2026) | TGRS Research Map | TGRS