ericrisco/rsc-harness / skills/connect-tool
connect-tool
VerifiedUse when the user names a specific tool to connect to the agent (an ERP, accounting or desktop program, CRM, WhatsApp, a spreadsheet, a database): research its real docs first, and when none exist, diagnose the program with the user and keep going. Picks the safest route, builds `01-TOOLS/<TOOL>/` with a test that proves it. NOT a full typed API client (that is `api-connector-builder`), NOT a whole-workspace tooling scan (that is `harness`).
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 16.4 KB |
| THIRD_PARTY.md | markdown | 2.8 KB |
| bridge-kit/01-TOOLS-plantilla/test_connection.shexecutable | script | 1.6 KB |
| bridge-kit/LICENSE | other | 1.2 KB |
| bridge-kit/README.md | markdown | 4.1 KB |
| bridge-kit/UPSTREAM.json | config | 219 B |
| bridge-kit/access/access_a_sqlite.pyexecutable | script | 3.5 KB |
| bridge-kit/dbhub/dbhub.toml.ejemplo | other | 2.5 KB |
| bridge-kit/red/cloudflared-config.yml.ejemplo | other | 1.1 KB |
| bridge-kit/red/tailscale-grants.hujson | other | 930 B |
| bridge-kit/sqlserver/01-login-servidor.sql | other | 1.1 KB |
| bridge-kit/sqlserver/02-usuario-y-vistas.sql | other | 2.9 KB |
| bridge-kit/sqlserver/03-prueba-solo-lectura.sql | other | 2.0 KB |
| bridge-kit/sqlserver/copia-nocturna.ps1 | script | 3.3 KB |
| evals/cases.yaml | config | 8.4 KB |
| references/connect-or-migrate.md | markdown | 5.8 KB |
| references/database-bridge.md | markdown | 9.7 KB |
| references/file-exchange.md | markdown | 7.9 KB |
| references/messages.md | markdown | 5.9 KB |
| references/program-types.md | markdown | 5.8 KB |
| references/spain.md | markdown | 7.1 KB |
| references/what-to-find-out.md | markdown | 4.0 KB |
bridge-kit/dbhub/dbhub.toml.ejemplo
View on GitHub# Kit puente · Configuración de DBHub (https://github.com/bytebase/dbhub, MIT).
#
# Este fichero lleva la contraseña de ia_lectura: guárdalo en el SERVIDOR DEL ERP, en una
# carpeta que solo pueda leer la cuenta que ejecuta DBHub. NUNCA en git ni en el portátil.
#
# Arranque (DBHub escucha por defecto en 0.0.0.0: indica SIEMPRE --host):
# set DBHUB_AUTH_TOKEN=<token largo y aleatorio>
# npx @bytebase/dbhub@<versión fija> --config=C:\KitPuente\dbhub.toml --transport http --host 127.0.0.1 --port 8080
# Con Tailscale (sin Cloudflare): --host <IP de Tailscale del servidor> y en el firewall de Windows
# permite el 8080 solo desde la interfaz de Tailscale (ver ../red/).
#
# Marcadores de parámetros en SQL Server: @p1, @p2… (en SQLite: ?).
# --- Origen: la COPIA nocturna (ver ../sqlserver/copia-nocturna.ps1) --------------------
[[sources]]
id = "erp_ia"
type = "sqlserver"
host = "127.0.0.1"
port = 1433
database = "ERP_IA"
user = "ia_lectura"
password = "<<CONTRASEÑA DE ia_lectura>>"
# Alternativa para Access convertido a SQLite (ver ../access/access_a_sqlite.py):
# [[sources]]
# id = "erp_ia"
# dsn = "sqlite:///C:/KitPuente/empresa.sqlite"
# --- execute_sql: la documentación no explica cómo quitarlo, así que se deja en solo
# lectura y con tope de filas. La garantía real es el login ia_lectura, que solo puede
# hacer SELECT sobre el esquema ia (pasa la prueba 03 antes de conectar nada).
[[tools]]
name = "execute_sql"
source = "erp_ia"
readonly = true
max_rows = 200
# --- Herramientas de SQL predefinido: una por pregunta de negocio ------------------------
[[tools]]
name = "ventas_por_dia"
description = "Base imponible y número de facturas emitidas por día entre dos fechas (AAAA-MM-DD)"
source = "erp_ia"
statement = "SELECT fecha, base_imponible, facturas FROM ia.ventas_por_dia WHERE fecha BETWEEN @p1 AND @p2 ORDER BY fecha"
[[tools.parameters]]
name = "desde"
type = "string"
description = "Fecha inicial, AAAA-MM-DD"
[[tools.parameters]]
name = "hasta"
type = "string"
description = "Fecha final, AAAA-MM-DD"
[[tools]]
name = "cobros_pendientes"
description = "Vencimientos de clientes con importe pendiente, del más antiguo al más reciente"
source = "erp_ia"
statement = "SELECT TOP (200) cliente, nombre, vencimiento, pendiente FROM ia.cobros_pendientes ORDER BY vencimiento"
[[tools]]
name = "stock_bajo_minimos"
description = "Artículos con stock por debajo del mínimo"
source = "erp_ia"
statement = "SELECT TOP (200) articulo, descripcion, stock, minimo FROM ia.stock_bajo_minimos ORDER BY stock - minimo"
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| finishing-a-development-branchobra/superpowersUse when implementation is complete, all tests pass, and you need to decide how to integrate the work | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| systematic-debuggingobra/superpowersUse when encountering any bug, test failure, or unexpected behavior, before proposing fixes | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| test-driven-developmentobra/superpowersUse when implementing any feature or bugfix, before writing implementation code | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| skill-creatoranthropics/skillsCreate new skills, modify and improve existing skills, and measure skill performance. Use when users want to create a skill from scratch, edit, or optimize an existing skill, run evals to test a skill, benchmark skill performance with variance analysis, or optimize a skill's description for better triggering accuracy. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |