skills.rest
Canner
CannerOFFICIAL
Explore all skills by this author →
Website𝕏@getwrenaiGitHub

generate-mdl

Generate a Wren MDL manifest by introspecting database schemas via ibis-server metadata endpoints.

663|199|Updated May 9, 2022
Search Tags:#database#schema#metadata#manifest#generate#mdl#ibis-server
One-click install
npx skills add https://github.com/Canner/wren-engine --skill generate-mdl
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: generate-mdl
Source: https://github.com/Canner/wren-engine/tree/main/skills/generate-mdl
Command: npx skills add https://github.com/Canner/wren-engine --skill generate-mdl

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Generates a Wren MDL manifest by using ibis-server to introspect the database schema — no local database drivers required.

Core Features & Use Cases

  • Auto-discover database schemas through ibis-server metadata endpoints to generate MDL models.
  • Support multi-datasource environments (e.g., PostgreSQL, BigQuery, Snowflake) by inferring models, columns, and relationships.
  • No local drivers required; works entirely through the ibis-server API to scaffold and validate manifests.

Quick Start

Connect to your ibis-server and run this skill to generate an initial MDL manifest from your database schema.

Frequently Asked Questions about generate-mdl

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

FAQPage Schema
How do I generate a database schema manifest without installing local drivers?▼

You can generate a database schema manifest without local drivers by running an ibis-server instance and using its metadata endpoints to introspect schemas and scaffold a Wren MDL manifest remotely.

Can I generate Wren MDL models from multiple data sources like PostgreSQL and BigQuery?▼

Yes, you can generate Wren MDL models from multiple data sources like PostgreSQL, BigQuery, and Snowflake by using ibis-server to infer models, columns, and relationships across different database schemas.

What is needed to start generating MDL manifests from existing database schemas?▼

To start generating MDL manifests from database schemas, you need a running ibis-server instance accessible at its default port 8000, along with network access to its metadata endpoints to introspect the target database.

How does introspecting a database schema via ibis-server work for onboarding new data sources?▼

Introspecting a database schema via ibis-server works by querying metadata endpoints to auto-discover tables and relationships, which scaffolds a Wren MDL manifest to onboard new data sources into your environment.

Does generating a Wren MDL manifest work for migrating schemas into a new data platform?▼

Yes, generating a Wren MDL manifest works for migrating schemas by introspecting your existing database structure through ibis-server and producing a validated manifest to map into the Wren MDL format.

Why should I use ibis-server API endpoints instead of direct database connections for manifest generation?▼

Using ibis-server API endpoints instead of direct database connections for manifest generation avoids the need to install and maintain local database drivers, allowing entirely remote schema introspection and validation.

Related Skills

Explore More Data & Analytics Skills→
jr2804jr2804

database-schema

Generates database schemas, ORM/ODM models, migrations, and FastAPI endpoints from JSON entity specifications.

Community
Advanced
treasure-datatreasure-data
21

trino-cli

Execute SQL queries against Treasure Data using the Trino CLI.

Official
Intermediate
vZulinvZulin

notion-automation

Automate Notion page, database, block, comment, and user tasks via Rube MCP.

Community
Intermediate
hamchowderrhamchowderr
2

wispr

Analyze local Wispr Flow dictation data in SQLite databases.

Community
Intermediate