Skill UI

This skill automates the creation of comprehensive documentation for relational databases (PostgreSQL/MySQL). By introspecting live schemas, it extracts detailed metadata including table structures, column descriptions, primary/foreign key relationships, indexes, views, and stored procedures. The output provides a data dictionary, entity-relationship map, and schema statistics, crucial for knowledge transfer and database lifecycle management.

Generates production-ready stored procedures, functions, and triggers for PostgreSQL, MySQL, or SQL Server by analyzing requirements, using the stored-procedure-generator plugin, and returning optimized SQL code for complex logic, integrity, and transaction safety.

This tool facilitates the migration of stored procedures and functions from Oracle PL/SQL to PostgreSQL PL/pgSQL. It handles complex syntax translation, preserves function signatures and type-anchored parameters, and manages explicit collation mapping. Use this when converting an existing Oracle database schema or application logic to a PostgreSQL environment.