A detailed technical documentation skill providing the complete MySQL database schema and entity relationships for Teamgram Server developers.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install teamgram-database-schema
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install teamgram-database-schema using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Teamgram Database Schema Reference?
The Teamgram Database Schema skill serves as a comprehensive knowledge base for developers working with the Teamgram Server. It indexes all 43 tables within the MySQL database, providing structural details, key constraints, and core entity relationships necessary for backend development and database management.
This skill is specifically designed for Openclaw Skills users who need immediate access to schema definitions without manually parsing SQL migration files. It covers everything from user authentication keys to complex chat participant mappings and message storage logic.
Teamgram Database Schema Reference Use Cases
Primary Scenarios
- Investigating MySQL table structures for Teamgram Server backend development.
- Mapping Entity-Relationship (ER) models between users, messages, and chats.
- Designing data migration scripts or custom extensions for the Teamgram ecosystem.
- Onboarding new developers to the Teamgram data architecture.
How Teamgram Database Schema Reference Works
- The skill acts as a documentation-only reference within the Openclaw Skills framework.
- It analyzes the
1_teamgram.sqland subsequent migration scripts from the official Teamgram repository. - It organizes the database structure into logical categories like Auth, Users, Chats, and Messages.
- It provides developers with quick lookups for specific fields, such as Snowflake ID primary keys and MTProto authorization mapping.
Teamgram Database Schema Reference Setup
Implementation
This is a documentation and knowledge skill. To utilize it within your Openclaw Skills environment, ensure you have the reference linked in your workspace:
# Navigate to your project directory
cd teamgram-server/deploy/sql/
# Reference the schema data within your AI agent context
openclaw add skill teamgram-database-schema
Teamgram Database Schema Reference Data Schema & Taxonomy
Core Table Structure
The database uses the utf8mb4 character set. Below are the primary entities defined in this Openclaw Skills reference:
| Entity Group | Primary Tables | Description |
|---|---|---|
| Authentication | auth_keys, auth_users | Manages MTProto keys and device-user bindings. |
| User Management | users, user_presences | Core profile data and last-seen status. |
| Messaging | messages, dialogs | Inbox/outbox storage and conversation metadata. |
| Groups | chats, chat_participants | Group membership, permissions, and invitations. |
| Files | documents, photos | Metadata for media and encrypted file transfers. |
Teamgram Database Schema Reference Advanced Features
- Mapping of Snowflake IDs for global unique identification across the
userstable. - Detailed breakdown of
inbox/outboxdouble-writing logic in themessagestable. - Support for multi-device login tracking via
auth_key_idSHA1 mapping. - Detailed privacy and notification settings taxonomy for individual user peers.
- Integration ready for Openclaw Skills agents to perform schema-aware code generation.
SKILL.md
Loading
Related Openclaw Skills
Hashtag Reference Tool
A lightweight, offline reference tool for devtools documentation, implementation patterns, and best practices.
GIMP CLI-Anything Skill
A specialized CLI bridge that enables AI agents to perform professional image editing tasks using GIMP within the Openclaw Skills ecosystem.
Teamgram Biz Service Documentation
A comprehensive documentation skill detailing the core business logic layer of the Teamgram Server, featuring six essential gRPC sub-services.
ColorLab
A comprehensive command-line tool for color conversion, palette generation, and WCAG accessibility auditing.
Teamgram Tool Services Knowledge Base
A comprehensive technical reference for managing core infrastructure services within the Teamgram Server ecosystem.
Teamgram BFF Aggregation Layer Reference
A detailed technical map of the Backend-for-Frontend (BFF) layer in Teamgram Server, detailing all 268 RPC handlers for Telegram-compatible API development.
Featured*
