datamodel2markdown
Reactive icon

DataModel2Markdown

Stable version 1.0.4 (Compatible with OutSystems 11)
Uploaded
 on 19 Feb
 by 
5.0
 (2 ratings)
datamodel2markdown

DataModel2Markdown

Details
Automatically extracts the data model from OutSystems meta-model and converts it to text using Markdown syntax. This tool is designed to give context to AI assistants, supporting us when working with SQL queries.
Read more

This tool creates structured, schema-aware context from your OutSystems applications, enabling AI assistants like Copilot to generate accurate SQL queries.

How it works

  1. Select your OutSystems application / eSpace
  2. Select the level of detail you want the schema representation to have
  3. The Markdown is automatically generated according to these options
  4. Copy and paste it into your AI assistant
  5. Get a query that matches your schema!

Level of detail

AI assistants like Copilot have a limited context window, meaning they only accept a certain amount of text. This makes it important to balance the richness of the data model context with the size of your prompt.

With that in mind, you can choose the mode that best fits your use case:

  • Default - Just entity and attribute names with relationships
  • Include Descriptions - Includes entity and attribute descriptions for better AI understanding
  • Include Attribute Details - Full attribute specifications including data types, lengths, and constraints


Data Privacy & Tooling

  • Use your company or client-approved AI tools only
  • Do not paste sensitive or production data into public AI tools
Release notes (1.0.4)

Minor bug fix.

Added information regarding Indexes to help LLMs have a comprehensive context about your data model:

  1. Clustered vs Non-Clustered - Critical for query optimisation understanding
  2. Foreign Key Relationships - Helps understand data relationships
  3. Included Columns - Important for covering index strategy
  4. Unique constraints - For data integrity understanding

Example:

## Indexes

### Application 
- PK_OSSYS_APPLICATION (Primary Key, Clustered): ID ASC 
- OSIDX_OSSYS_APPLICATION_3KEY (Unique, Non-Clustered): KEY ASC 
- OSIDX_OSSYS_APPLICATION_9CREATEDBY (Non-Clustered): CREATEDBY ASC  
   - Supports FK: Application.CreatedBy -> User [On Delete: Protect]

License (1.0.4)
Reviews (0)
Team
Other assets in this category