skills.rest
Unique-Divine
Unique-DivineCOMMUNITY
Explore all skills by this author →
Website𝕏@UniqueDivineGitHub

sai-db

Reference the sai-keeper Postgres database schema for querying Sai exchange data.

6|1|Updated Sep 23, 2023
Search Tags:#database schema#data retrieval#on-chain data#sai-keeper#exchange analytics
One-click install
npx skills add https://github.com/Unique-Divine/jiyuu --skill sai-db
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sai-db
Source: https://github.com/Unique-Divine/jiyuu/tree/main/ai-skills/sai-db
Command: npx skills add https://github.com/Unique-Divine/jiyuu --skill sai-db

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides quick and easy access to the Sai database schema and data, enabling users to understand and interact with the Sai exchange's indexed data efficiently.

Core Features & Use Cases

  • Database Schema Reference: Offers comprehensive documentation of the sai-keeper Postgres database schema, tables, and columns.
  • Data Patterns Understanding: Helps interpret common data coordinates, units, and partitioning conventions.
  • APIsurfacing: Maps database tables to corresponding GraphQL and REST API endpoints for easy data retrieval.
  • Use Case: A user can use this skill to understand how on-chain data is stored in the Sai exchange and to quickly access specific market, trading, and user data.

Quick Start

Use the sai-db skill to fetch information about the latest daily open interest in the Sai exchange.

Frequently Asked Questions about sai-db

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

FAQPage Schema
How do I query the Sai exchange database schema for on-chain market data?▼

You can query the Sai exchange database schema by using SQL against the sai-keeper Postgres database, which stores indexed on-chain market, trading, and user data for retrieval.

What is the structure of the sai-keeper Postgres database for exchange analytics?▼

The sai-keeper Postgres database structure includes comprehensive tables, columns, and data relationships that map on-chain data coordinates, units, and partitioning conventions for exchange analytics.

How do I map sai-keeper database tables to REST or GraphQL API endpoints?▼

You can map sai-keeper database tables to REST and GraphQL API endpoints using the provided schema reference, which surfaces database entries for simplified on-chain data retrieval.

Do I need SQL knowledge to retrieve daily open interest from the Sai exchange?▼

Yes, you need SQL knowledge and direct access to the sai-keeper Postgres database to query and retrieve specific indexed data like the latest daily open interest in the Sai exchange.

How do I interpret data patterns and partitioning conventions in the Sai exchange database?▼

You interpret data patterns and partitioning conventions in the Sai exchange database by referencing the schema documentation, which details common data coordinates, units, and relational structures.

Related Skills

Explore More Data & Analytics Skills→
NicholasSutinNicholasSutin

supabase-postgres-best-practices

Apply Postgres performance and security best practices for schema design and query execution.

Community
Advanced
storyclaw-officialstoryclaw-official

market-monitor

Monitor cryptocurrency markets via Binance and OKX APIs with technical indicators.

Official
Intermediate
Unique-DivineUnique-Divine
6

sai-keeper-graphql

Query the Sai GraphQL API for trading data, liquidity, and analytics on Nibiru Chain.

Community
Advanced
hefgihefgi
7

ponder

Configure and run a multi-chain blockchain indexer with Ponder.

Community
Advanced