Seeking Guidance: Integrating AI to Analyze Database Structure & Optimize Stored Procedures in Adminer

[pervilla]

Hello everyone,

I've been struggling for several days with a stored procedure that appears to be executing successfully but isn't inserting any records into the database. I suspect that a trigger might be interfering with the insert operation, though I haven't been able to pinpoint the exact cause.

As I use Adminer for database management, I started wondering: how can I integrate AI tools or techniques to help analyze my database structure, identify potential conflicts (like triggers blocking inserts), and optimize my stored procedures?

My goal is to leverage AI to:

Review the database schema, triggers, and dependencies.

Detect issues that may prevent data insertion (e.g., trigger logic errors or conflicts).

Suggest improvements for the stored procedure to ensure it works as intended.

Has anyone tried integrating AI with Adminer or similar tools for this kind of task? I’d appreciate any advice, tools, or methodologies you recommend to troubleshoot and resolve this issue.

Thanks in advance for your insights!

[vrana]

There're sql-gemini, sql-wizard and sql-claude plugins.