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

Ready to run

npx skills add https://github.com/Unique-Divine/jiyuu --skill sai-db

💬 Prompt for ChatGPT / Claude Chat▼

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.