{"id":1762,"date":"2026-08-13T01:48:48","date_gmt":"2026-08-13T01:48:48","guid":{"rendered":"https:\/\/vykhodtsev.dev\/?p=1762"},"modified":"2026-08-13T01:48:48","modified_gmt":"2026-08-13T01:48:48","slug":"%f0%9f%a7%a0-adding-business-rules-to-my-ai-sql-agent","status":"publish","type":"post","link":"https:\/\/vykhodtsev.dev\/?p=1762","title":{"rendered":"\ud83e\udde0 Adding Business Rules to My AI SQL Agent"},"content":{"rendered":"\n

Another step in the development of my AI SQL Agent: I\u2019ve added a centralized Business Rules layer that allows me to control how the AI Agent works with the database without hardcoding every instruction into the application logic.
Instead of relying only on a large system prompt, I created a dedicated database table where architectural and business rules can be stored, maintained, and provided to the AI Agent as part of its working context.
For example, an architecture rule can define standards for creating dimension tables:
\u27a1\ufe0f When a user asks the Agent to create a dimension table, it must include:
Code \u2014 default length 3
Name \u2014 default length 20
So instead of simply generating whatever table structure the LLM considers appropriate, the Agent follows the architectural standards defined for the environment.
Another example is a business rule for inventory movement.
If a user asks:
“Move 10 units of Product A from Warehouse 1 to Warehouse 2.”
the Agent understands that this operation should create two records in the moving_product table:
Warehouse 1 \u2192 -10
Warehouse 2 \u2192 +10
The important idea here is that the AI Agent does not need to “know” these organization-specific rules during model training.
The rules become part of the data and configuration layer.
User Request \u2192 AI Agent \u2192 Relevant Business \/ Architecture Rules \u2192 SQL Generation \u2192 Database
This creates an interesting separation of responsibilities:
\ud83e\udd16 AI Agent \u2014 understands the user’s intent and generates the required actions
\ud83d\udccb Rules Layer \u2014 defines how those actions must be performed in a specific environment
\ud83d\uddc4\ufe0f Database \u2014 executes the controlled SQL operations
For me, this is an important step toward moving an AI SQL Agent from a simple natural-language-to-SQL demo toward an assistant that can operate within defined enterprise standards and business processes.
It also opens the door to managing rules centrally, activating or deactivating them, adding new rules without changing the Agent’s core code, and eventually applying different rule sets to different environments or use cases.<\/p>\n\n\n\n

#AI<\/strong><\/a>#AIAgents<\/strong><\/a>#ArtificialIntelligence<\/strong><\/a>#GenerativeAI<\/strong><\/a>#SQL<\/strong><\/a>#DataEngineering<\/strong><\/a>#SolutionArchitecture<\/strong><\/a>#BusinessRules<\/strong><\/a>#EnterpriseAI<\/strong><\/a>#Database<\/strong><\/a>#AzureOpenAI<\/strong><\/a>#Python<\/strong><\/a>#FastAPI<\/strong><\/a>#Automation<\/strong><\/a>#DataArchitecture<\/strong><\/a><\/p>\n\n\n\n

\"screenshot<\/figure>\n","protected":false},"excerpt":{"rendered":"

Another step in the development of my AI SQL Agent: I\u2019ve added a centralized Business Rules layer that allows me to control how the AI Agent works with the database without hardcoding every instruction into the application logic.Instead of relying only on a large system prompt, I created a dedicated database table where architectural and […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1762","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"spectra_blocks_featured_image_url":null,"spectra_blocks_author_info":{"display_name":"Aleksei","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/198b25ea575ebb3cbd0934cb05fd942d0f256a65d3ff388a161c857e00b092bf?s=96&d=mm&r=g","author_link":"https:\/\/vykhodtsev.dev\/?author=1","description":""},"_links":{"self":[{"href":"https:\/\/vykhodtsev.dev\/index.php?rest_route=\/wp\/v2\/posts\/1762","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vykhodtsev.dev\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vykhodtsev.dev\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vykhodtsev.dev\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/vykhodtsev.dev\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1762"}],"version-history":[{"count":1,"href":"https:\/\/vykhodtsev.dev\/index.php?rest_route=\/wp\/v2\/posts\/1762\/revisions"}],"predecessor-version":[{"id":1764,"href":"https:\/\/vykhodtsev.dev\/index.php?rest_route=\/wp\/v2\/posts\/1762\/revisions\/1764"}],"wp:attachment":[{"href":"https:\/\/vykhodtsev.dev\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1762"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vykhodtsev.dev\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1762"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vykhodtsev.dev\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1762"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}