I am one of those developers who gets plenty of Trivadis warnings when using SQLcl CodeScan.
My current idea is to use AI coding agents together with SQLcl MCP and CodeScan so that the AI learns to produce cleaner PL/SQL before the code reaches the database.
As a small experiment I put together this PoC:
https://github.com/vaaPo/oracle-sqlcl-mcp-trivadis-poc
The workflow is:
- AI agents modify SQL files in Git
- SQLcl CodeScan validates Trivadis rules
- Humans review and execute changes
- Database remains the source of truth
My question: are there any Oracle-provided AI skills, prompts, or best practices specifically for Trivadis guidelines and SQLcl CodeScan?
P.S. If you find anything useful in the repository, please steal it shamelessly.
Regards,
Paavo