oracle-dbWrite Oracle SQL and PL/SQL with proper syntax, hints, and performance patterns.
Install via ClawdBot CLI:
clawdbot install ivangdavila/oracle-dbGrade Fair — based on market validation, documentation quality, package completeness, maintenance status, and authenticity signals.
Generated Mar 1, 2026
Generating daily transaction reports with pagination for large datasets, using ROWNUM or FETCH FIRST for performance. Implementing hierarchical queries to analyze organizational structures in financial data, with proper NULL handling for empty values.
Managing order sequences with Oracle sequences for unique order IDs, handling date arithmetic for shipping estimates, and using bind variables in PL/SQL blocks to process transactions efficiently while preventing SQL injection.
Querying patient history with hierarchical CONNECT BY queries for family medical trees, using NVL/NVL2 for handling missing data, and implementing pagination for browsing large medical record sets with proper transaction control.
Monitoring inventory levels with real-time queries using SYSDATE for timestamping, implementing performance hints for large inventory tables, and using DECODE or CASE statements for status categorization across multiple warehouses.
Processing billing cycles with PL/SQL blocks for complex calculations, using TO_DATE and TO_CHAR for date formatting in invoices, and implementing SAVEPOINT and ROLLBACK for error recovery during batch billing operations.
Selling Oracle database licenses to large corporations for mission-critical applications, with annual maintenance fees and optional premium support packages. Revenue comes from per-core licensing models and additional tools like Oracle Enterprise Manager.
Providing specialized Oracle SQL and PL/SQL development services, performance tuning, and migration assistance from other databases. Revenue streams include hourly consulting rates, fixed-price projects, and retainer agreements for ongoing support.
Building and hosting software-as-a-service applications using Oracle Autonomous Database, with subscription-based pricing tiers. Revenue generated from monthly/user fees with premium features for advanced Oracle-specific functionality like hierarchical queries and PL/SQL automation.
💬 Integration Tip
Ensure sqlplus or SQL binaries are available in the system PATH, and set SERVEROUTPUT ON for PL/SQL debugging output. Use bind variables in all dynamic SQL to prevent hard parsing and improve performance.
Scored Apr 18, 2026
Use the @steipete/oracle CLI to bundle a prompt plus the right files and get a second-model review (API or browser) for debugging, refactors, design checks, or cross-validation.
Local search/indexing CLI (BM25 + vectors + rerank) with MCP mode.
Design data models for construction projects. Create entity-relationship diagrams, define schemas, and generate database structures.
MarkItDown is a Python utility from Microsoft for converting various files (PDF, Word, Excel, PPTX, Images, Audio) to Markdown. Useful for extracting structu...
Connect to Supabase for database operations, vector search, and storage. Use for storing data, running SQL queries, similarity search with pgvector, and managing tables. Triggers on requests involving databases, vector stores, embeddings, or Supabase specifically.
Use when designing database schemas, writing migrations, optimizing SQL queries, fixing N+1 problems, creating indexes, setting up PostgreSQL, configuring EF Core, implementing caching, partitioning tables, or any database performance question.