All Topics
All Topics
Technology
Technology
Design
Design
Programming
Programming
Science
Science
News
News
Gaming
Gaming
Entertainment
Entertainment
Business
Business
Finance
Finance
Sports
Sports
Health
Health
Food
Food
Travel
Travel
Art
Art
Music
Music
Books
Books
Education
Education
Politics
Politics
Personal
Personal
No algorithm. No AI slop. No ads. Just RSS. Pro-human. Indie writers. Real journalism. Open web. Chronological. Hand toasted.

Shed: CLI Tool for Database Schema Management with SQLModel and JSON-Schema Export

By

PonyM

7mo ago· 4 min readenCode

Summary

Shed is a CLI tool for database schema management that uses SQLModel ORM and Alembic for migrations. It helps developers manage database schemas without raw SQL and provides JSON-schema export for Pydantic BaseModel v2. The tool is useful for ETL projects, managing database models in git repositories, and validating data from external sources like LLM outputs.

Key quotes

· 4 pulled
shed is a cli tool that acts like an application for your database schemas management using SQLModel orm and manages them for you using alembic
You get free json-schema export for all your pydantic.BaselModel (v2)
You can create your database models git repo that only manages db models, using shed to manage db and schemas
Are you doing some ETL project, you don't want to manage your database schema with raw SQL, and maybe validate data from external tools using those schemas e.g. when using LLM output?
Snippet from the RSS feed
Collection of db and json-schemas. Contribute to gh-PonyM/shed development by creating an account on GitHub.

You might also wanna read