skills.rest
genlayerlabs
genlayerlabsOFFICIAL
Explore all skills by this author →
Website𝕏@genlayerGitHub

studio-db

Query PostgreSQL databases to debug GenLayer Studio transaction processing.

157|60|Updated Mar 16, 2024
Search Tags:#debugging#database#sql#transactions#postgres#genlayer
One-click install
npx skills add https://github.com/genlayerlabs/genlayer-studio --skill studio-db
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: studio-db
Source: https://github.com/genlayerlabs/genlayer-studio/tree/main/.claude/skills/studio-db
Command: npx skills add https://github.com/genlayerlabs/genlayer-studio --skill studio-db

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill allows developers to directly query and debug PostgreSQL databases used by the GenLayer Studio, specifically for analyzing and resolving transaction issues.

Core Features & Use Cases

  • Transaction Debugging: Inspect transaction details, status, and history within the genlayer_state database.
  • Schema Exploration: Understand the structure of key tables like transactions, current_state, and validators.
  • Use Case: When a transaction fails or gets stuck in the GenLayer Studio, use this Skill to query the transactions table by its hash to understand its status, consensus data, and identify the cause of the failure.

Quick Start

Use the studio-db skill to find transaction by hash '0x...'.

Frequently Asked Questions about studio-db

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I debug a stuck transaction in PostgreSQL using SQL queries?▼

You can debug a stuck GenLayer Studio transaction by querying the 'transactions' table by its hash to inspect status, consensus data, and history within the 'genlayer_state' database to identify the failure cause.

What is the best way to inspect GenLayer Studio transaction consensus history?▼

Inspect GenLayer Studio consensus history by executing SQL queries against the 'genlayer_state' PostgreSQL database to analyze transaction lifecycles, contract states, and validator data.

Do I need kubectl and psql to query the GenLayer Studio database?▼

Yes, you need kubectl for secure database access and psql for direct query execution against the 'genlayer_state' database to debug GenLayer Studio transaction processing and analyze chain state.

How do I explore the database schema for GenLayer Studio tables like current_state and validators?▼

Explore the GenLayer Studio database schema by running SQL queries via psql to understand the structure of key tables like 'transactions', 'current_state', and 'validators' within the PostgreSQL database.

What SQL queries can I run to analyze contract states in GenLayer Studio?▼

Run SQL queries using psql against the 'genlayer_state' PostgreSQL database to inspect contract states, transaction details, and validator information for debugging GenLayer Studio chain state.

Related Skills

Explore More Software Engineering Skills→
dversozadversoza
2

postgres

Query PostgreSQL databases read-only via psql for schema introspection and EXPLAIN plans.

Community
Intermediate
proven-xyzproven-xyz
2

genlayer-cli

Deploy, interact with, and debug GenLayer contracts using the GenLayer CLI.

Official
Advanced
proven-xyzproven-xyz
2

integration-tests

Automate end-to-end GenLayer workflow validation against GLSim, Studio, or testnet.

Official
Advanced
Unique-DivineUnique-Divine
6

postgresql-psql

Manage PostgreSQL databases and execute SQL queries via psql.

Community
Advanced