skills.rest
glideapps
glideappsOFFICIAL
Explore all skills by this author →
Website𝕏@glideappsGitHub

data-modeling

Design Glide data models with tables, columns, and relationships.

10|Updated Dec 30, 2025
Search Tags:#data-modeling#tables#relations#columns#Glide#Big Tables#Data Editor
One-click install
npx skills add https://github.com/glideapps/glide-code --skill data-modeling-glideapps
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-modeling
Source: https://github.com/glideapps/glide-code/tree/main/glide/skills/data-modeling
Command: npx skills add https://github.com/glideapps/glide-code --skill data-modeling-glideapps

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Glide apps rely on well-structured data models to power filtering, relations, and calculations. This Skill guides you through designing tables, selecting column types, and establishing relationships to build scalable, reliable apps.

Core Features & Use Cases

  • Column Types Overview: Basic columns for storage and computed columns for calculations, including Math, Template, If-Then-Else, and Lookup.
  • Relationship Patterns: Use Row IDs, foreign keys, and Relation/Lookup/Rollup to connect data across tables.
  • Big Tables and Data Sharing: Guidance on when to use Big Tables for shared data across apps and API access.
  • Data Architecture Best Practices: Naming conventions, documentation, testing calculations with sample data.

Quick Start

  • Create a new Glide table, add a Row ID column as the primary key, add 2-3 basic columns (Text, Number), then create a Relation to a second table (e.g., Customers -> Orders). Add a Lookup and a Rollup to summarize related data. Validate the model with sample data and adjust column types as needed.

Frequently Asked Questions about data-modeling

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

FAQPage Schema
How do I design a data model for a Glide app?▼

Design a Glide data model by creating tables with Row ID primary keys, adding basic columns (Text, Number) for storage, and establishing Relations between tables. Use Lookup and Rollup columns to connect and summarize related data across your app's tables.

What column types should I use in Glide tables?▼

Glide offers basic columns (Text, Number, etc.) for data storage and computed columns for calculations. Computed types include Math, Template, If-Then-Else, and Lookup. Choose based on whether you're storing raw data or deriving values from existing columns.

When should I use Big Tables in Glide?▼

Use Big Tables when you need to share data across multiple Glide apps or provide API access. Big Tables support larger datasets and cross-app data sharing, making them ideal for centralized data architecture serving multiple applications.

How do I create relationships between Glide tables?▼

Create relationships by using Row IDs as primary keys, then establish Relations with foreign keys to link tables. Add Lookup columns to pull data from related records and Rollup columns to aggregate values across relationships.

What are data architecture best practices for Glide apps?▼

Follow naming conventions for clarity, document your structure, and validate calculations using sample data. Test column types and relationships before deployment, and plan your Relations and Rollups to ensure reliable filtering and calculations across your data model.

Can I access Glide table data through APIs?▼

Yes, Big Tables in Glide support API data access, allowing external systems to read and write data. This enables integration with other tools and automation workflows while maintaining your data model's structure and relationships.

Related Skills

Explore More Data & Analytics Skills→
glideappsglideapps
10

api

Manage Glide Big Tables data via REST API v2 and @glideapps/tables.

Official
Intermediate
glideappsglideapps
10

computed-columns

Define and apply computed columns across Glide Tables rows.

Official
Basic
glideappsglideapps
10

app-audit

Analyze Glide apps to detect performance bottlenecks in data structures and layouts.

Official
Advanced
glideappsglideapps
10

ai

Enable AI columns in Glide apps to generate text and extract media data.

Official
Basic