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/03-prueba-solo-lectura.sql
View on GitHub/*
Kit puente · 03 · Prueba de aceptación: ia_lectura LEE y NO ESCRIBE.
Sin esta prueba el puente no se entrega. Se ejecuta como administrador; el script
se hace pasar por ia_lectura (EXECUTE AS) y todo va dentro de una transacción
que se deshace al final, así que no cambia nada aunque algo fallara.
Sustituye <tabla_facturas_emitidas> por una tabla real del programa.
DELETE/UPDATE con TOP (0) no tocan ninguna fila, pero SQL Server comprueba igualmente
el permiso: si ia_lectura lo tuviera, la prueba lo detecta.
*/
USE [ERP_IA];
GO
BEGIN TRANSACTION;
EXECUTE AS USER = N'ia_lectura';
DECLARE @fallos int = 0;
BEGIN TRY
SELECT TOP (1) * FROM [ia].[ventas_por_dia];
PRINT N'OK · puede leer las vistas del esquema ia';
END TRY
BEGIN CATCH
SET @fallos += 1; PRINT N'FALLO · no puede leer ia.ventas_por_dia: ' + ERROR_MESSAGE();
END CATCH;
BEGIN TRY
SELECT TOP (1) * FROM [dbo].[<tabla_facturas_emitidas>];
SET @fallos += 1; PRINT N'FALLO · puede leer las tablas directamente (solo debería ver el esquema ia)';
END TRY
BEGIN CATCH
PRINT N'OK · no puede leer las tablas directamente';
END CATCH;
BEGIN TRY
DELETE TOP (0) FROM [dbo].[<tabla_facturas_emitidas>];
SET @fallos += 1; PRINT N'FALLO · tiene permiso de DELETE';
END TRY
BEGIN CATCH
PRINT N'OK · no puede borrar';
END CATCH;
BEGIN TRY
UPDATE TOP (0) [dbo].[<tabla_facturas_emitidas>] SET <columna_fecha> = <columna_fecha>;
SET @fallos += 1; PRINT N'FALLO · tiene permiso de UPDATE';
END TRY
BEGIN CATCH
PRINT N'OK · no puede modificar';
END CATCH;
BEGIN TRY
EXEC (N'CREATE TABLE [ia].[prueba_escritura] (x int)');
SET @fallos += 1; PRINT N'FALLO · puede crear tablas';
END TRY
BEGIN CATCH
PRINT N'OK · no puede crear tablas';
END CATCH;
REVERT;
ROLLBACK TRANSACTION;
IF @fallos = 0 PRINT N'RESULTADO: OK — ia_lectura es de solo lectura.';
ELSE PRINT N'RESULTADO: REVISAR — hay ' + CAST(@fallos AS nvarchar(10)) + N' fallos. No conectes el agente.';
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 |