Relational Data Modeling

aid: relational-data-modeling
name: Relational Data Modeling
description: >-
  Relational data modeling is a database design approach that organizes data into
  tables (relations) with rows and columns, establishing relationships between tables
  through primary and foreign keys to ensure data integrity and minimize redundancy.
  This index covers leading platforms, tools, and APIs for relational data modeling
  including ER diagram tools, schema design platforms, DDL generation services, and
  database design automation.
type: Index
image: https://kinlane-productions.s3.amazonaws.com/apis-json/apis-json-logo.jpg
tags:
  - Data Architecture
  - Database Design
  - Entity Relationship
  - Normalization
  - SQL
  - Schema Design
  - Data Modeling
url: >-
  https://raw.githubusercontent.com/api-evangelist/relational-data-modeling/refs/heads/main/apis.yml
created: '2025-01-01'
modified: '2026-05-02'
specificationVersion: '0.19'
apis:
  - aid: relational-data-modeling:sqldbm
    name: SqlDBM Cloud Data Modeling Platform
    description: >-
      SqlDBM is a cloud-based data modeling platform focused on ER design-to-DDL
      workflows with collaborative reviews. It supports common relational database
      targets and helps standardize naming conventions, constraints, and indexes
      through model-driven design.
    humanURL: https://sqldbm.com/
    tags:
      - SQL
      - ER Diagrams
      - DDL Generation
      - Collaboration
      - Cloud
    properties:
      - type: Documentation
        url: https://sqldbm.com/
      - type: Website
        url: https://sqldbm.com/

  - aid: relational-data-modeling:hackolade
    name: Hackolade Data Modeling
    description: >-
      Hackolade is a data modeling tool that supports both SQL and NoSQL databases,
      JSON schemas, and APIs. It enables schema design for MongoDB, Cassandra,
      DynamoDB, PostgreSQL, and other platforms through visual ER modeling.
    humanURL: https://hackolade.com/
    tags:
      - NoSQL
      - SQL
      - JSON Schema
      - Schema Design
      - Multi-Database
    properties:
      - type: Documentation
        url: https://hackolade.com/
      - type: Website
        url: https://hackolade.com/

  - aid: relational-data-modeling:er-studio
    name: ER/Studio Data Modeling
    description: >-
      ER/Studio is an enterprise-grade logical and physical data modeling platform
      with strong metadata management capabilities. It handles large, enterprise-scale
      data models and provides comprehensive data governance features.
    humanURL: https://erstudio.com/
    tags:
      - Enterprise
      - Metadata Management
      - Physical Data Model
      - Logical Data Model
      - Data Governance
    properties:
      - type: Documentation
        url: https://erstudio.com/
      - type: Website
        url: https://erstudio.com/

  - aid: relational-data-modeling:dbschema
    name: DbSchema Database Design
    description: >-
      DbSchema is a database design and management tool that provides a visual
      interface for creating and maintaining database schemas across both relational
      and NoSQL databases, with schema synchronization and query building features.
    humanURL: https://dbschema.com/
    tags:
      - Visual Modeling
      - Schema Synchronization
      - Multi-Database
      - SQL
    properties:
      - type: Documentation
        url: https://dbschema.com/
      - type: Website
        url: https://dbschema.com/

common:
  - type: Website
    url: https://en.wikipedia.org/wiki/Relational_model
  - type: Reference
    url: https://en.wikipedia.org/wiki/Entity%E2%80%93relationship_model
  - type: Reference
    url: https://en.wikipedia.org/wiki/Database_normalization
  - type: JSONSchema
    url: >-
      https://raw.githubusercontent.com/api-evangelist/relational-data-modeling/refs/heads/main/json-schema/relational-data-modeling-entity-schema.json
  - type: JSONLDContext
    url: >-
      https://raw.githubusercontent.com/api-evangelist/relational-data-modeling/refs/heads/main/json-ld/relational-data-modeling-context.jsonld
  - type: Vocabulary
    url: >-
      https://raw.githubusercontent.com/api-evangelist/relational-data-modeling/refs/heads/main/vocabulary/relational-data-modeling-vocabulary.yml

maintainers:
  - FN: Kin Lane
    email: [email protected]