Database Knowledge Skill

Purpose

1. Query — Get database info (DDL from db-agent, context from local docs)
2. Document — Auto-save new findings to dc-docs repository

Query Flow

User: "расскажи про таблицу dostavkaRN"
                ↓
1. Search database/descriptions/dostavkaRN.md
                ↓
   Found? → Return with DDL from db-agent
                ↓
   Not found? → Query db-agent, CREATE new file, return

How to Query Database

db-agent (current)

DB_AGENT="/mnt/windows-c/Users/IuriiPurych/DataGripProjects/DCLG/b2b/BMPI-1797-Orders/sql/db-agent"

# Table structure
$DB_AGENT --action ddl --table "TableName"

# SQL query
$DB_AGENT --action query "SELECT TOP 10 * FROM TableName"

# Indexes
$DB_AGENT --action indexes --table "TableName"

MCP (when available)

Use mcp__db__* tools directly.

Auto-Documentation Rules

When you learn something new about a table:

Create/Update: database/descriptions/<table_name>.md

# <TableName>

> Auto-documented: YYYY-MM-DD

## Purpose
<What this table stores, one sentence>

## Key Fields
| Field | Type | Business Meaning |
|-------|------|------------------|
| field1 | int | Description |

## Important Notes
- <business rules, gotchas, tips>

When you discover a relation:

Update: database/relations/<domain>.md

## <Table1> ↔ <Table2>

- **Link:** Table1.field → Table2.field
- **Type:** 1:1 / 1:N / N:M
- **Notes:** <when/why this relation is used>

When you learn business logic:

Create/Update: domains/<domain>/<topic>.md

# <Topic>

## Rule
<clear statement of the rule>

## Applies To
- Tables: X, Y, Z
- Procedures: A, B

## Examples
<concrete examples>

File Naming

• Tables: database/descriptions/<table_lowercase>.md
• Relations: database/relations/<domain>.md (orders, dropshipping, warehouse)
• Dictionaries: database/dictionaries/<name>.md
• Business logic: domains/<domain>/<topic>.md

Database Servers

Response Format

Always return:

1. DDL (from db-agent)
2. Context (from docs or "Not documented yet")
3. Action taken ("Documented in database/descriptions/x.md" or "Already documented")