db-coding-agent

Plugin db-coding-agent from marketplace software-agents-team in gagandeepp/software-agent-teams. Commands read from the repo's manifest — 1 month ago.

Skills (10)

• artifact-validator

  Use before writing any database artifact (migration, stored procedure, view, function, seed, index) to detect duplicates by path, name, content similarity, and structural overlap. Blocks duplicate creation with P1 BLOCK and requests human intervention when confidence is ambiguous.

• code-review

  Use when reviewing database artifacts before completion — performs engine-aware review by delegating to the active engine module's coding skill and validating against resolved guidelines

• commit-push-pr

  Use when committing, pushing, and raising a PR — stages changed files, writes a Conventional Commits message, pushes to the remote branch, creates a GitHub PR via gh CLI, then posts the PR URL to configured Slack or Teams channels for review. Channel targets are configurable via .commit-push-pr.json

• config-resolver

  Use when resolving database coding agent configuration — reads .db-agent.json, merges with per-invocation overrides, validates governance constraints, and returns the resolved engine, framework, migration tool, and guidelines path

• db-detection

  Use when auto-detecting the database engine for the current file or directory — scans file extensions, config files, build artifacts, and connection string patterns to identify SQL Server, PostgreSQL, MongoDB, or Azure Cosmos DB

• db-guardrails

  Use at the start and end of every database coding session — thin adapter invoking shared guardrails gates with DB-specific context. Adds DROP/TRUNCATE guard check (P0), missing rollback script detection (P1), and connection string in source detection (P0). Coverage skipped (null). Uses sqlfluff for

• guidelines-ingestion

  Use when loading and merging coding guidelines for the active database engine — performs deterministic section-level merge of plugin defaults, team custom guidelines, and per-invocation overrides into a single instruction set

• query-optimiser

  Use when analysing or optimising database query performance — reads execution plans, identifies bottlenecks, recommends index changes, rewrites inefficient queries, and validates improvements across SQL Server, PostgreSQL, MongoDB, and Azure Cosmos DB

• db-repo-setup

  Connects the database coding agent to a GitHub repository. In init mode, prompts the user for a GitHub repo URL, local clone path, and authentication method, then writes the repository block to .db-agent.json. In runtime mode, checks whether the local clone exists and clones it if absent — before co

• write-db-tests

  Use when writing tests for database artifacts — delegates to the active engine module's testing skill for framework-specific patterns (tSQLt, pgTAP, jest, xUnit) and enforces coverage and structure standards

Slash commands (2)

• /db-coding-agent:db-init

  Initialize .db-agent.json config and check database tool prerequisites

• /db-coding-agent:db-review

  Run engine-aware code review against team database coding guidelines

Subagents (1)

• db-coder

  Use this agent when you need to create database artifacts, write migrations, design schemas, or manage database code for SQL Server, PostgreSQL, MongoDB, or Azure Cosmos DB. This agent auto-detects the database engine from context or config, loads team coding guidelines, uses LSP for diagnostics, an

Hooks (4)

• SessionStart

  "${CLAUDE_PLUGIN_ROOT}/hooks/run-session-start"

• PreToolUse

  "${CLAUDE_PLUGIN_ROOT}/hooks/run-pretooluse-artifact-check"

• PostToolUse

  "${CLAUDE_PLUGIN_ROOT}/hooks/run-posttooluse-sync"

• Stop

  "${CLAUDE_PLUGIN_ROOT}/hooks/run-stop-memory"

Similar plugins