Codebase-Aware Prompt Engine (n8n + MySQL)
n8n + MySQL prompt engine that seeds ERP codebase excerpts and generates codebase-aware multi-task batch prompts with TMS mapping.
Overview
RoyalSoft Prompt Engine MVP6 stores codebase profiles and file excerpts in MySQL, bridges n8n Code nodes to live data, and generates grounded developer prompts in batches.
Problem
Generic LLM prompts ignore the live ERP codebase. Teams need prompts grounded in real file excerpts and company conventions.
Solution
Node tooling applies MySQL schema, seeds excerpts from ERP ZIPs, runs a local MySQL bridge for n8n, and imports the MVP6 hybrid workflow for batch generation.
Architecture
ERP ZIP seed → MySQL (profiles/excerpts/prompts/batches/TMS) ← MySQL bridge ← n8n workflow → UI / generated prompt history.
Implementation
Node.js scripts (schema, bridge, seed, preflight, E2E), mysql2, n8n workflow JSON import, optional UI server and OpenAI secret sync.
Results
Permanent, codebase-aware prompt generation for ERP development tasks with batch history and TMS config.
Key modules
- MySQL schema
- Bridge server
- n8n MVP6 workflow
- Seed & E2E scripts
Features
- MySQL tables for profiles, excerpts, prompts, batches, TMS config
- Seed pipeline for large ERP ZIPs
- Local MySQL bridge for n8n Code nodes
- Multi-task hybrid batch generation workflow
- E2E unknown-task test scripts
Outcomes
- Codebase-grounded prompts instead of generic LLM requests
Related projects
AI-Powered Enterprise PHP Code Generation System
Django platform that learns Royal ERP PHP conventions from uploaded codebases and generates deployment-ready modules with validation and ZIP packaging.
SDLC Automation Bot — Meeting to Tasks
Next.js control panel plus n8n workflows that turn meeting transcripts into Claude-treated requirements and TMS tasks via Recall.ai bots.