skills.rest
mainsequence-sdk
mainsequence-sdkOFFICIAL
Explore all skills by this author →
WebsiteGitHub

mainsequence-meta-tables

Automate SQLAlchemy MetaTable model creation, registration, and governed SQL operations.

1|Updated Apr 12, 2026
Search Tags:#sqlalchemy#alembic#meta-table#meta-table-management#meta-table-definition
One-click install
npx skills add https://github.com/mainsequence-sdk/SdkAgentTraining --skill mainsequence-meta-tables
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: mainsequence-meta-tables
Source: https://github.com/mainsequence-sdk/SdkAgentTraining/tree/main/sdk/4.4.5/skills/data_publishing/meta_tables/source
Command: npx skills add https://github.com/mainsequence-sdk/SdkAgentTraining --skill mainsequence-meta-tables

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines the definition, querying, and review of Main Sequence MetaTables, which are essential for schema-driven application tables registered through TS Manager.

Core Features & Use Cases

  • MetaTable Definition: Automates SQLAlchemy table model creation and registration for MetaTable resources.
  • Table Management: Supports both platform-managed and external_registered table management modes.
  • Compiled SQL Operations: Allows the definition of governed read and write operations on MetaTables.
  • Migration Management: Directs Alembic migration lifecycle work through the MetaTable migration skill.
  • Use Case: If you need to update a row-oriented project table that isn't a DataNode and is registered as a MetaTable, use this Skill to ensure the schema changes are handled correctly.

Quick Start

Use the 'mainsequence-meta-tables' skill to create a new SQLAlchemy MetaTable model and register it as a 'MetaTable' resource.

Frequently Asked Questions about mainsequence-meta-tables

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

FAQPage Schema
How do I define and register a SQLAlchemy MetaTable model?▼

To define a SQLAlchemy MetaTable model, you must automate SQLAlchemy table model creation and register it as a MetaTable resource through the TS Manager for schema-driven application workflows.

What is the difference between platform-managed and external_registered MetaTable modes?▼

Platform-managed MetaTables are handled directly by the platform, whereas external_registered MetaTables allow you to manage table schemas externally while still governing compiled SQL operations.

When should I use a MetaTable instead of a DataNode for row-oriented project tables?▼

You should use a MetaTable when you need to update row-oriented project tables that are not DataNodes, ensuring schema changes are handled correctly through proper registration and governance.

How do I manage Alembic migrations for SQLAlchemy MetaTables?▼

You manage Alembic migrations for SQLAlchemy MetaTables by directing the migration lifecycle work through the dedicated MetaTable migration skill, ensuring schema changes are properly applied.

Can I govern read and write operations on registered MetaTables?▼

Yes, you can define governed compiled SQL read and write operations on MetaTables, ensuring that schema-driven application development workflows maintain proper data management.

What are the limitations of using external_registered MetaTable management?▼

External_registered MetaTable management requires proper MetaTable registration and governance of compiled SQL operations, limiting direct platform control while supporting external schema modifications.

Related Skills

Explore More Software Engineering Skills→
mainsequence-sdkmainsequence-sdk
1

mainsequence-metatable-migrations

Manage MetaTable schema evolution using Alembic migrations in Main Sequence.

Official
Advanced
T-ravT-rav
5

hf.enforce-migrations

Block direct SQL DDL in non-migration files during Edit and Write operations.

Community
Advanced
Lord1EgyptLord1Egypt
2

biopython

Manipulate biological sequences and query NCBI databases with Biopython.

Community
Advanced
jeffstricjeffstric
187

database-migration

Automate Alembic database schema migrations with create, apply, and rollback.

Community
Advanced