simonw / simonw/sqlite-utils

Command to generate a visual schema diagram?

Open
#622 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Python
Stars
2.2k
Forks
172
Avg merge
9m
Merged PRs (30d)
1

Description

It would be helpful to see the schema of a db more visually, with an output to pdf, image or so...

Example: sqlite-utils schema-diagram dogs.db generated a visual schema diagram

image

Perhaps using something like https://gitlab.com/Screwtapello/sqlite-schema-diagram or suitable alternative

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by evaluating the proposed sqlite-utils schema-diagram command and the referenced sqlite-schema-diagram project as possible implementation approaches. Define what schema elements and output formats should be supported, with completion demonstrated by generating a readable visual diagram from dogs.db as PDF or an image.

Written by the indexing model from the issue text.

Assessment

Tech stack
python, sqlite
Domain
cli, databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.