# Send Database to your agent Hand the extracted package to your coding agent with a concrete install brief instead of figuring it out manually. ## Fast path - Download the package from Yavira. - Extract it into a folder your agent can access. - Paste one of the prompts below and point your agent at the extracted folder. ## Suggested prompts ### New install ```text I downloaded a skill package from Yavira. Read SKILL.md from the extracted folder and install it by following the included instructions. Tell me what you changed and call out any manual steps you could not complete. ``` ### Upgrade existing ```text I downloaded an updated skill package from Yavira. Read SKILL.md from the extracted folder, compare it with my current installation, and upgrade it while preserving any custom configuration unless the package docs explicitly say otherwise. Summarize what changed and any follow-up checks I should run. ``` ## Machine-readable fields ```json { "schemaVersion": "1.0", "item": { "slug": "db", "name": "Database", "source": "tencent", "type": "skill", "category": "数据分析", "sourceUrl": "https://clawhub.ai/ivangdavila/db", "canonicalUrl": "https://clawhub.ai/ivangdavila/db", "targetPlatform": "OpenClaw" }, "install": { "downloadUrl": "/downloads/db", "sourceDownloadUrl": "https://wry-manatee-359.convex.site/api/v1/download?slug=db", "sourcePlatform": "tencent", "targetPlatform": "OpenClaw", "packageFormat": "ZIP package", "primaryDoc": "SKILL.md", "includedAssets": [ "SKILL.md" ], "downloadMode": "redirect", "sourceHealth": { "source": "tencent", "slug": "db", "status": "healthy", "reason": "direct_download_ok", "recommendedAction": "download", "checkedAt": "2026-05-01T10:09:32.474Z", "expiresAt": "2026-05-08T10:09:32.474Z", "httpStatus": 200, "finalUrl": "https://wry-manatee-359.convex.site/api/v1/download?slug=db", "contentType": "application/zip", "probeMethod": "head", "details": { "probeUrl": "https://wry-manatee-359.convex.site/api/v1/download?slug=db", "contentDisposition": "attachment; filename=\"db-1.0.0.zip\"", "redirectLocation": null, "bodySnippet": null, "slug": "db" }, "scope": "item", "summary": "Item download looks usable.", "detail": "Yavira can redirect you to the upstream package for this item.", "primaryActionLabel": "Download for OpenClaw", "primaryActionHref": "/downloads/db" }, "validation": { "installChecklist": [ "Use the Yavira download entry.", "Review SKILL.md after the package is downloaded.", "Confirm the extracted package contains the expected setup assets." ], "postInstallChecks": [ "Confirm the extracted package includes the expected docs or setup files.", "Validate the skill or prompts are available in your target agent workspace.", "Capture any manual follow-up steps the agent could not complete." ] } }, "links": { "detailUrl": "https://openagent3.xyz/skills/db", "downloadUrl": "https://openagent3.xyz/downloads/db", "agentUrl": "https://openagent3.xyz/skills/db/agent", "manifestUrl": "https://openagent3.xyz/skills/db/agent.json", "briefUrl": "https://openagent3.xyz/skills/db/agent.md" } } ``` ## Documentation ### Connection Traps Connection pools exhausted = app hangs silently — set max connections, monitor pool usage Each Lambda/serverless invocation may open new connection — use connection pooling proxy (RDS Proxy, PgBouncer) Connections left open block schema changes — ALTER TABLE waits for all transactions Idle connections consume memory — set connection timeout, kill idle connections ### Transaction Gotchas Long transactions hold locks and bloat MVCC — keep transactions short Read-only transactions still take snapshots — can block vacuum/cleanup in Postgres Implicit autocommit varies by database — explicit BEGIN/COMMIT is safer Deadlocks from inconsistent lock ordering — always lock tables/rows in same order Lost updates from read-modify-write without locking — use SELECT FOR UPDATE or optimistic locking ### Schema Changes Adding column with default rewrites entire table in old MySQL/Postgres — use NULL default, backfill, then alter Index creation locks writes in some databases — use CONCURRENTLY in Postgres, ONLINE in MySQL 8+ Renaming column breaks running application — add new column, migrate, drop old Dropping column with active queries causes errors — deploy code change first, then schema change Foreign key checks slow bulk inserts — disable constraints, insert, re-enable ### Backup and Recovery Logical backups (pg_dump, mysqldump) lock tables or miss concurrent writes — use consistent snapshot Point-in-time recovery requires WAL/binlog retention — configure before you need it Backup verification: restore regularly — backups that can't restore aren't backups Replication lag during backup can cause inconsistency — backup from replica, verify consistency ### Replication Traps Replication lag means stale reads — check lag before trusting replica data Writes to replica corrupt replication — make replicas read-only Schema changes can break replication — replicate schema changes, don't apply separately Split-brain after failover loses writes — use fencing/STONITH to prevent Promoting replica doesn't redirect connections — application must reconnect to new primary ### Query Patterns N+1 queries from ORM lazy loading — eager load relationships or batch queries Missing indexes on foreign keys slows joins and cascading deletes Large IN clauses become slow — batch into multiple queries or use temp table COUNT(*) on large tables is slow — use approximate counts or cache SELECT without LIMIT on unbounded data risks OOM ### Data Integrity Application-level unique checks have race conditions — use database constraints Check constraints often disabled for "flexibility" then data corrupts — keep them on Orphan rows from missing foreign keys — add constraints retroactively, clean up first Timezone confusion: store UTC, convert on display — never store local time without zone Floating point for money causes rounding errors — use DECIMAL or integer cents ### Scaling Limits Single table over 100M rows needs sharding strategy — plan before you hit it Autovacuum falling behind causes table bloat — monitor dead tuple ratio Query planner statistics stale after bulk changes — ANALYZE after large imports Connection count doesn't scale linearly — more connections = more lock contention Disk IOPS often bottleneck before CPU — monitor I/O wait ## Trust - Source: tencent - Verification: Indexed source record - Publisher: ivangdavila - Version: 1.0.0 ## Source health - Status: healthy - Item download looks usable. - Yavira can redirect you to the upstream package for this item. - Health scope: item - Reason: direct_download_ok - Checked at: 2026-05-01T10:09:32.474Z - Expires at: 2026-05-08T10:09:32.474Z - Recommended action: Download for OpenClaw ## Links - [Detail page](https://openagent3.xyz/skills/db) - [Send to Agent page](https://openagent3.xyz/skills/db/agent) - [JSON manifest](https://openagent3.xyz/skills/db/agent.json) - [Markdown brief](https://openagent3.xyz/skills/db/agent.md) - [Download page](https://openagent3.xyz/downloads/db)