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/sqlserver/02-usuario-y-vistas.sql
View on GitHub/*
Kit puente · 02 · Usuario, esquema "ia" y vistas (nivel de BASE DE DATOS).
Se ejecuta en la base que lee el agente. Por defecto es la COPIA "ERP_IA".
Es IDEMPOTENTE: copia-nocturna.ps1 lo vuelve a lanzar después de cada restauración,
porque restaurar la copia borra el usuario, el esquema y las vistas.
Las vistas son PLANTILLAS: los nombres de tablas y columnas dependen del programa
y de su versión. Complétalos con el distribuidor o con la documentación del esquema.
Regla: solo las columnas necesarias. Sin IBAN, sin datos de salud, sin nóminas.
*/
-- Cambia el nombre si no usas la copia:
USE [ERP_IA];
GO
IF NOT EXISTS (SELECT 1 FROM sys.schemas WHERE name = N'ia')
EXEC (N'CREATE SCHEMA [ia] AUTHORIZATION [dbo]');
GO
IF NOT EXISTS (SELECT 1 FROM sys.database_principals WHERE name = N'ia_lectura')
CREATE USER [ia_lectura] FOR LOGIN [ia_lectura] WITH DEFAULT_SCHEMA = [ia];
GO
-- Solo lectura sobre el esquema de vistas. Las vistas son de dbo (dueño del esquema),
-- así que la cadena de propiedad deja leer las tablas a través de ellas sin dar
-- permiso directo sobre las tablas.
GRANT SELECT ON SCHEMA::[ia] TO [ia_lectura];
ALTER ROLE [db_denydatawriter] ADD MEMBER [ia_lectura];
DENY CREATE TABLE TO [ia_lectura];
DENY CREATE VIEW TO [ia_lectura];
DENY CREATE PROCEDURE TO [ia_lectura];
DENY CREATE FUNCTION TO [ia_lectura];
GO
/* ----------------------------------------------------------------------------
VISTAS (plantillas). Sustituye <…> por las tablas y columnas reales.
Una vista por "pregunta de negocio". DBHub expone cada una como herramienta.
---------------------------------------------------------------------------- */
CREATE OR ALTER VIEW [ia].[ventas_por_dia] AS
SELECT
CAST(f.<columna_fecha> AS date) AS fecha,
SUM(f.<columna_base_imponible>) AS base_imponible,
COUNT(*) AS facturas
FROM [dbo].[<tabla_facturas_emitidas>] AS f
GROUP BY CAST(f.<columna_fecha> AS date);
GO
CREATE OR ALTER VIEW [ia].[cobros_pendientes] AS
SELECT
c.<columna_codigo_cliente> AS cliente,
c.<columna_nombre_cliente> AS nombre,
v.<columna_vencimiento> AS vencimiento,
v.<columna_importe_pendiente> AS pendiente
FROM [dbo].[<tabla_vencimientos>] AS v
JOIN [dbo].[<tabla_clientes>] AS c ON c.<columna_codigo_cliente> = v.<columna_codigo_cliente>
WHERE v.<columna_importe_pendiente> > 0;
GO
CREATE OR ALTER VIEW [ia].[stock_bajo_minimos] AS
SELECT
a.<columna_codigo_articulo> AS articulo,
a.<columna_descripcion> AS descripcion,
s.<columna_stock> AS stock,
a.<columna_stock_minimo> AS minimo
FROM [dbo].[<tabla_articulos>] AS a
JOIN [dbo].[<tabla_stock>] AS s ON s.<columna_codigo_articulo> = a.<columna_codigo_articulo>
WHERE s.<columna_stock> < a.<columna_stock_minimo>;
GO
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 |