Query Studio deployment PostgreSQL databases for transaction debugging and analytics
$ npx skills add genlayerlabs/genlayer-studio --skill studio-db -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install genlayerlabs/genlayer-studio studio-db --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/genlayerlabs/genlayer-studio.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.claude/skills/studio-db .claude/skills/studio-db && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "studio-db" agent skill from https://github.com/genlayerlabs/genlayer-studio/tree/main/.claude/skills/studio-db into .claude/skills/studio-db/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "studio-db", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/genlayerlabs/genlayer-studio/tree/main/.claude/skills/studio-dbType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add genlayerlabs/genlayer-studio --skill studio-db -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install genlayerlabs/genlayer-studio studio-db --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/genlayerlabs/genlayer-studio.git skills-src && mkdir -p .agents/skills && cp -r skills-src/.claude/skills/studio-db .agents/skills/studio-db && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "studio-db" agent skill from https://github.com/genlayerlabs/genlayer-studio/tree/main/.claude/skills/studio-db into .agents/skills/studio-db/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "studio-db", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add genlayerlabs/genlayer-studio --skill studio-db -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install genlayerlabs/genlayer-studio studio-db --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/genlayerlabs/genlayer-studio.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/.claude/skills/studio-db .cursor/skills/studio-db && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "studio-db" agent skill from https://github.com/genlayerlabs/genlayer-studio/tree/main/.claude/skills/studio-db into .cursor/skills/studio-db/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "studio-db", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/genlayerlabs/genlayer-studio.git --path .claude/skills/studio-db--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add genlayerlabs/genlayer-studio --skill studio-db -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install genlayerlabs/genlayer-studio studio-db --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/genlayerlabs/genlayer-studio.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/.claude/skills/studio-db .gemini/skills/studio-db && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "studio-db" agent skill from https://github.com/genlayerlabs/genlayer-studio/tree/main/.claude/skills/studio-db into .gemini/skills/studio-db/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "studio-db", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install genlayerlabs/genlayer-studio studio-dbInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add genlayerlabs/genlayer-studio --skill studio-db -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/genlayerlabs/genlayer-studio.git skills-src && mkdir -p .github/skills && cp -r skills-src/.claude/skills/studio-db .github/skills/studio-db && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "studio-db" agent skill from https://github.com/genlayerlabs/genlayer-studio/tree/main/.claude/skills/studio-db into .github/skills/studio-db/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "studio-db", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add genlayerlabs/genlayer-studio --skill studio-db -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install genlayerlabs/genlayer-studio studio-db --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/genlayerlabs/genlayer-studio.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/.claude/skills/studio-db .opencode/skills/studio-db && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "studio-db" agent skill from https://github.com/genlayerlabs/genlayer-studio/tree/main/.claude/skills/studio-db into .opencode/skills/studio-db/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "studio-db", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
studio-dbQuery Studio deployment PostgreSQL databases for transaction debugging and analytics
Studio DB is an agent skill from genlayerlabs/genlayer-studio. Query Studio deployment PostgreSQL databases for transaction debugging and analytics
Its SKILL.md is about 1.3k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.
It sits in Development, covering Debugging. It works with PostgreSQL. The repository describes itself as: An interactive sandbox to explore the GenLayer Protocol. The licence is MIT.
3 steps, taken from the first numbered list in SKILL.md.
Read from SKILL.md and the folder at commit c940729. It shows what the files ask for, not the result of running them.
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Shell commands in SKILL.md call:
kubectlpsqlFrom the folder's file list and the shell code blocks in SKILL.md.
No URLs in SKILL.md. Its commands use kubectl, which can reach the network depending on how they are called.
From URLs in SKILL.md, links to its own repository left out.
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Studio DB loads about 1.3k tokens when it runs. Until then it costs about 24 tokens; SKILL.md has 256 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
The automated check found no risky patterns in SKILL.md.
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
The full file from genlayerlabs/genlayer-studio at commit c940729, republished under its MIT licence (© genlayerlabs). 256 words, ~1,256 tokens.
.claude/skills/studio-db/SKILL.md (or your agent's skills folder).Query and debug the genlayer_state database for transaction issues.
For cluster access setup and connection workflow, see:
devexp-apps-workload/.claude/skills/studio-db/SKILL.md
Quick connect (after setup):
export PATH="/opt/homebrew/share/google-cloud-sdk/bin:/opt/homebrew/bin:$PATH"
DBHOST=$(kubectl get secret database-config -n <namespace> -o jsonpath='{.data.DBHOST}' | base64 -d)
DBPASSWORD=$(kubectl get secret database-password -n <namespace> -o jsonpath='{.data.DBPASSWORD}' | base64 -d)
echo "<SQL>" | kubectl run pg-query --rm -i --image=postgres:16 --restart=Never \
--namespace=<namespace> --env="PGPASSWORD=$DBPASSWORD" -- \
psql -h "$DBHOST" -p 5432 -U postgres -d genlayer_state -tPrimary table for debugging (transactions):
| Column | Type | Description |
|---|---|---|
| hash | VARCHAR(66) | Primary key, tx identifier |
| status | ENUM | Transaction lifecycle status |
| from_address | VARCHAR | Sender address |
| to_address | VARCHAR | Recipient/contract address |
| nonce | INTEGER | Tx sequence number |
| value | INTEGER | Transaction value |
| type | INTEGER | Tx type (0-3) |
| created_at | TIMESTAMP | When tx was created |
| input_data | JSONB | Contract call input |
| data | JSONB | Transaction data payload |
| consensus_data | JSONB | Final consensus results |
| consensus_history | JSONB | Full voting history |
| contract_snapshot | JSONB | Contract state at execution |
| appealed | BOOLEAN | Was tx appealed |
| appeal_failed | INTEGER | Appeal failure count |
| appeal_undetermined | BOOLEAN | Appeal resulted in undetermined |
| appeal_leader_timeout | BOOLEAN | Leader timeout during appeal |
| appeal_validators_timeout | BOOLEAN | Validators timeout during appeal |
| leader_timeout_validators | JSONB | Validators that timed out |
| worker_id | VARCHAR | Which worker processed tx |
| triggered_by_hash | VARCHAR(66) | Parent tx hash (for tx chains) |
| blocked_at | TIMESTAMP | When/if tx got blocked |
PENDING → ACTIVATED → PROPOSING → COMMITTING → REVEALING → ACCEPTED → FINALIZED
↘ UNDETERMINED
↘ LEADER_TIMEOUT
↘ VALIDATORS_TIMEOUT
↘ CANCELEDid, data JSONB, balance)id, address, stake, provider, model, plugin)snapshot_id, state_data, transaction_data)SELECT hash, status, from_address, to_address, created_at,
consensus_data, worker_id
FROM transactions WHERE hash = '0x...';SELECT hash, status, created_at, worker_id
FROM transactions
WHERE status IN ('UNDETERMINED', 'LEADER_TIMEOUT', 'VALIDATORS_TIMEOUT')
ORDER BY created_at DESC LIMIT 20;SELECT status, COUNT(*) as count
FROM transactions
GROUP BY status ORDER BY count DESC;SELECT hash, status, from_address, created_at
FROM transactions ORDER BY created_at DESC LIMIT 10;SELECT hash, status, appealed, appeal_undetermined, appeal_failed,
appeal_leader_timeout, appeal_validators_timeout
FROM transactions WHERE appealed = true
ORDER BY created_at DESC LIMIT 20;SELECT t1.hash as parent, t2.hash as child, t2.status
FROM transactions t1
JOIN transactions t2 ON t2.triggered_by_hash = t1.hash
WHERE t1.hash = '0x...';SELECT worker_id, status, COUNT(*)
FROM transactions
WHERE created_at > NOW() - INTERVAL '24 hours'
GROUP BY worker_id, status
ORDER BY worker_id, count DESC;SELECT hash, status,
jsonb_pretty(consensus_history) as history
FROM transactions WHERE hash = '0x...';CAUTION: Before any UPDATE/DELETE:
-- Verify first
SELECT hash, status FROM transactions
WHERE hash = '0x...' AND status = 'UNDETERMINED';
-- Then update (after confirmation)
UPDATE transactions SET status = 'PENDING' WHERE hash = '0x...';Models: backend/database_handler/models.py
Migrations: backend/database_handler/migration/versions/
Tx processor: backend/database_handler/transactions_processor.py
© genlayerlabs, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
Just SKILL.md in .claude/skills/studio-db of genlayerlabs/genlayer-studio.
Open the folder on GitHubat commit c940729
Studio DB next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Studio DB this skillgenlayerlabs/genlayer-studio | 180 | — | ~1.3k | Automated safety check: Pass | MIT | |
| Supabase Advanced Troubleshootingjeremylongshore/tons-of-skills-marketplace | 2.8k | — | ~2.8k | Automated safety check: Pass | MIT | |
| Version Managementrelytcloud/pg_ducklake | 143 | — | ~455 | Automated safety check: Pass | MIT | |
| Supabase Development and Debuggingsupabase/agent-skills | 2.7k | 3 repos | ~3.6k | Automated safety check: Pass | MIT | |
| Safe SQL Executionsupabase/supabase | 111k | — | ~4.2k | Automated safety check: Pass | Apache-2.0 | |
| Golang Databaseunxed/f4 | 241 | 2 repos | ~2.9k | Automated safety check: Pass | MIT |
jeremylongshore/tons-of-skills-marketplace
Deep Supabase diagnostics: pgstatstatements for slow queries, lock debugging with pglocks, connection leak detection, RLS policy conflicts, Edge Function cold starts, and Realtime connection drop…
relytcloud/pg_ducklake
Versioning, branch, and release policy (semantic versioning, branch-per-minor, tag-per-patch).
supabase/agent-skills
General Supabase skill for database, auth, Edge Functions, Realtime and storage work, plus client libraries, migrations, security audits, debugging and reading logs.
supabase/supabase
A skill your agent uses whenever code will build, return, fetch, or execute SQL that runs against a user's real Postgres database — even when the request reads like an ordinary feature or bug fix…
unxed/f4
Comprehensive guide for Go database access — parameterized queries, struct scanning, NULLable columns, transactions, isolation levels, SELECT FOR UPDATE, connection pool, batch processing, context…
xiaou61/Code-Nest
Code-Nest 多模块全栈项目协作规范与落点导航。Use when modifying this repository for feature development, bug fixing, refactor, API change, SQL migration, or frontend-backend联调 so changes land in the correct module…
genlayerlabs/genlayer-studio
Debug and manage Cloudflare DNS, cache, and proxy settings using flarectl
genlayerlabs/genlayer-studio
Create GitHub pull requests by analyzing branch diff and following the project template
genlayerlabs/genlayer-studio
Monitor Discord community channel for user-reported bugs and issues
genlayerlabs/genlayer-studio
Debug GenLayer Studio deployments via ArgoCD CLI. An agent skill from genlayerlabs/genlayer-studio.
genlayerlabs/genlayer-studio
Setup Python virtual environment and run integration tests with gltest
genlayerlabs/genlayer-studio
Fetch the most urgent Linear issue with tag "studio" and size XS, then fix it
Works with
Categories
Query Studio deployment PostgreSQL databases for transaction debugging and analytics. Studio DB is an agent skill from genlayerlabs/genlayer-studio.
Studio DB fits situations like: tasks that involve Debugging.
Run `npx skills add genlayerlabs/genlayer-studio --skill studio-db -a claude-code`. Or copy the skill folder (.claude/skills/studio-db in genlayerlabs/genlayer-studio) into .claude/skills/studio-db in your project. Claude Code loads it when a task matches its description.
Run `npx skills add genlayerlabs/genlayer-studio --skill studio-db -a codex`. Or copy the skill folder (.claude/skills/studio-db in genlayerlabs/genlayer-studio) into .agents/skills/studio-db in your project. Codex loads it when a task matches its description.
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add genlayerlabs/genlayer-studio --skill studio-db -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/studio-db, .gemini/skills/studio-db, .github/skills/studio-db and .opencode/skills/studio-db in your project.
Going by SKILL.md and its folder, Studio DB needs the command-line tools its instructions call (kubectl and psql).
SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
Studio DB is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.
About 1.3k tokens (SKILL.md is roughly 5k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
Skills that share tags, products or a category with Studio DB: Supabase Advanced Troubleshooting (jeremylongshore/tons-of-skills-marketplace, 2.8k stars), Version Management (relytcloud/pg_ducklake, 143 stars), Supabase Development and Debugging (supabase/agent-skills, 2.7k stars) and Safe SQL Execution (supabase/supabase, 111k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
genlayerlabs (a GitHub organization) maintains it in genlayerlabs/genlayer-studio, which has 180 GitHub stars. The repository holds 10 skills in this directory. The repository was last updated on October 7, 2026.
Source: genlayerlabs/genlayer-studio on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.
