DrOlu
- 109 skills
- 0 followers
- 2 days ago last updated
- ▌
- ▌ Dbcli Query · droluExecute SELECT queries on 30+ databases (SQLite, SQL Server, MySQL, PostgreSQL, Oracle, etc.) using DbCli. Returns data in JSON, table, or CSV format. Use when user needs to query databases, read data, or execute SELECT statements.
- ▌ Dbcli DB Ddl · droluExecute DDL (Data Definition Language) statements - CREATE, ALTER, DROP tables, indexes, views on 30+ databases using DbCli. CRITICAL - requires mandatory backup before DROP/ALTER operations. Use when user needs to create schema, modify structure, or drop database objects.
- ▌ Dbcli Export · droluExport table data as SQL INSERT statements from 30+ databases using DbCli. Essential for creating backups before dangerous modifications (UPDATE/DELETE/DROP). Use when user needs to backup data, migrate tables, or create portable SQL dumps.
- ▌ Dbcli Tables · droluList all tables in a database and show table structure (columns, types, constraints) for 30+ databases using DbCli. Use when user wants to explore database schema, see what tables exist, check table structure, or understand column definitions.
- ▌ Dbcli Compare · droluCompare results of two SQL queries to verify if they produce identical data. Checks structure, record count, and data content using MINUS/EXCEPT operations. Use when user needs to validate query equivalence, compare view logic, verify refactoring, or check data consistency.
- ▌ Dbcli Procedure · droluManage stored procedures, functions, and triggers (CREATE/ALTER/DROP operations)
- ▌ Dbcli Interactive · droluInteractive SQL mode for 30+ databases using DbCli. Provides REPL environment for exploratory queries, rapid prototyping, and database administration. Includes safety prompts before dangerous operations (UPDATE/DELETE/DROP). Use when user wants interactive database session.
- ▌ Dbcli Export Schema · droluExport database schema objects (procedures, functions, triggers, views, indexes) as SQL scripts for backup