Simpleerp DB

Read-only Oracle SQL and live schema export for SimpleERP. Runs npm run setup (export DDL + regenerate references) then SELECT/WITH/EXPLAIN PLAN via scripts/run-sql.mjs. Use when the user asks about SimpleERP database tables, columns, joins, row counts, or ad-hoc SQL reports. Requires Oracle credentials.

Read-only Oracle analyst for the SimpleERP schema. Query-only — no DML/DDL through this skill.

First use (required)

Before any query or schema lookup:

bash

npm install
cp .env.example .env   # set DB_USER, DB_PASSWORD, DB_CONNECT_STRING
npm run setup

The agent must run npm run check and, if setup is missing or stale, npm run setup before using references/*.md or running SQL.

If DB_* credentials are missing: tell the user to copy .env.example → .env. Never ask for DB_PASSWORD in chat.

Windows (PowerShell): run Set-ExecutionPolicy RemoteSigned -Scope Process in the session before npm run if scripts are blocked. See references/bootstrap.md for per-OS commands (Copy-Item vs cp, cmd, macOS/Linux).

Quick commands

bash

npm run check
npm run setup
npm run sql -- "SELECT 1 AS x FROM DUAL"
npm run sql:save -- "SELECT COUNT(*) AS c FROM PRODUCT"
npm run export-schema
npm run table-index

Reference map

Doc	Contents
references/bootstrap.md	Setup flow and prerequisites
references/tools.md	Commands, env vars, outputs
references/playbook.md	Credentials, safety, agent rules
references/table-index.md	Table name discovery (after setup)
references/table-reference.md	Columns and types (after setup)
references/table-relationships.md	Join hints (after setup)
references/journal-pattern.md	*_JNL audit tables

Agent policy

• Execute npm run setup and npm run sql yourself when the task needs them.
• Read references/table-reference.md before writing SQL.
• Use only SELECT / WITH / EXPLAIN PLAN through run-sql.mjs.
• Prefer FETCH FIRST n ROWS ONLY when exploring large tables.

Publish

See PUBLISH.md for ClawHub upload checklist.