All authors
Claude Skills by zademy
github.com/zademy21 skills0 installs1 views
- Ask MattAsk which skill or flow fits your situation. A router over the skills in this repo.Votes: 0GitHub stars: 2
- Code ReviewReview the changes since a fixed point (commit, branch, tag, or merge-base) along two axes: Standards (does the code follow this repo's documented coding standards?) and Spec (does the code match what the originating issue/spec asked for?). Runs both reviews in parallel sub-agents and reports them side by side. Use when the user wants to review a branch, a PR, work-in-progress changes, or asks to \"review since X\".Votes: 0GitHub stars: 2
- Diagnosing BugsDiagnosis loop for hard bugs and performance regressions. Use when the user says "diagnose"/"debug this", or reports something broken/throwing/failing/slow.Votes: 0GitHub stars: 2
- Implement SpecImplement the result of /to-spec and /to-tickets in code.Votes: 0GitHub stars: 2
- ImplementImplement a piece of work based on a spec or set of tickets.Votes: 0GitHub stars: 2
- Setup Matt Pocock SkillsConfigure this repo for the engineering skills: set up its issue tracker, triage label vocabulary, and domain doc layout. Run once before first use of the other engineering skills.Votes: 0GitHub stars: 2
- TddTest-driven development. Use when the user wants to build features or fix bugs test-first, mentions "red-green-refactor", or wants integration tests.Votes: 0GitHub stars: 2
- TeachTeach the user a new skill or concept, within this workspace.Votes: 0GitHub stars: 2
- To TicketsBreak a plan, spec, or the current conversation into a set of tracer-bullet tickets, each declaring its blocking edges, published to the configured tracker (edges as text in one file per ticket locally, or native blocking links on a real tracker).Votes: 0GitHub stars: 2
- TriageMove issues and external PRs through a state machine of triage roles, categorise, verify, grill if needed, and write agent-ready briefs.Votes: 0GitHub stars: 2
- WayfinderPlan a huge chunk of work (more than one agent session can hold) as a shared map of decision tickets on your issue tracker, and resolve them one at a time until the way to the destination is clear.Votes: 0GitHub stars: 2
- Lu Query Audit Data QualityUse lu-query to check Oracle data quality - find duplicate key candidates with find_duplicates, count orphan rows of a foreign key with validate_fk_integrity, and get exact table counts with count_rows. Use when auditing a table before migrating, deduplicating, or validating a legacy FK.Votes: 0GitHub stars: 2
- Lu Query Audit ReportTurn the lu-query audit trail into a single interactive HTML report - KPIs, per-day and per-hour activity, slowest statements, ORA error groups, READ/WRITE split, per-session table. Use when asked what was executed against the database over a period, for an audit or an activity report, or to review what an agent did in a session.Votes: 0GitHub stars: 2
- Lu Query Benchmark SqlMeasure a SQL statement before and after a rewrite - real execution stats from DBMS_XPLAN, repeated runs, a result fingerprint that proves the rows did not change, and one HTML report with the bottleneck list and the per-run curves. Use when the user asks why a query is slow, wants to compare two versions, or wants a tuning recommendation with numbers behind it.Votes: 0GitHub stars: 2
- Lu Query Explore SchemaUse lu-query to explore an unknown Oracle database - discover schemas, tables, views, indexes, constraints, triggers, procedures, sequences and partitions, read an object's DDL, and map dependencies with Mermaid graphs. Start here before writing any SQL against an unfamiliar schema. Covers 31 metadata and graph tools.Votes: 0GitHub stars: 2
- Lu Query Manage SchemaUse lu-query to change Oracle structure in the user's own schema - comments on tables and columns, views, synonyms, sequences, indexes and materialized-view logs. Use when the user asked for a DDL change and you must know its constraints, the columns argument shape, and what Oracle will refuse.Votes: 0GitHub stars: 2
- Lu Query Plan Data ChangesUse lu-query to change Oracle rows safely - preview the blast radius with execute_dml_preview, rehearse with execute_dml_rollback_first, commit with execute_dml, and pick new keys with find_free_id or get_next_sequence_value. Use for INSERT/UPDATE/DELETE/MERGE where the user approved the change.Votes: 0GitHub stars: 2
- Lu Query Query DataUse lu-query to answer a data question from Oracle with a read-only SELECT - run_query for arbitrary SELECTs with offset/limit pagination, get_sample_data for a quick row preview. Covers capped reads (1000 rows), when a specialized tool is better than SQL, how to read the row envelope, and how CLOB, BLOB, JSON and XML columns come back.Votes: 0GitHub stars: 2
- Lu Query Triage IncidentUse lu-query to triage an Oracle database incident - oracle_mcp_health_report for a readiness overview, list_active_sessions/list_blocked_sessions/list_locks/get_wait_events/get_session_longops for live sessions, get_session_sql_text and list_top_sql for what is running and what is expensive, get_instance_info/get_database_info/get_parameter/get_system_stats/get_db_time_model/list_datafile_io for the system, plus get_session_privs and get_session_roles.Votes: 0GitHub stars: 2
- Lu Query Tune SqlUse lu-query to diagnose slow or suspicious Oracle SQL - explain_plan for the real execution plan without running the statement, suggest_index for index DDL when a full scan is the problem, get_table_stats/get_column_stats/get_histogram for optimizer statistics, list_unused_indexes for index cleanup and run_sql_tuning_advisor for the advisor report.Votes: 0GitHub stars: 2
- Lu Query Use PlsqlUse lu-query to inspect and call Oracle PL/SQL - describe_plsql for arguments and source, call_procedure for procedures/functions/package subprograms with IN/OUT/INOUT parameters and SYS_REFCURSOR results, get_plsql_errors for compile failures. Use when a business operation lives in PL/SQL rather than in a table.Votes: 0GitHub stars: 2