search

Qovery / Replibyte

Seed your development database with real data ⚡️
https://www.replibyte.com
GNU General Public License v3.0
4.18k stars 129 forks source link

Show the source database schema #109

Closed evoxmusic closed 2 years ago

evoxmusic commented 2 years ago

As a user, I need to know what tables and columns are available if I need to set up the transformers and subset. It will be super convenient to show the source database schema with a command.

replibyte -c conf.yaml source schema

|    table    |    column    | 
...

Then we can analyze the table structure with potentially sensitive data and relations between tables.

realtimetodie commented 2 years ago

I'm working on this.

timkrins commented 2 years ago

I created myself a little Python script to give me a default configuration containing all the tables in my database.

https://gist.github.com/timkrins/ebfa00ce220439d7c3dbe2a309c1a426

It would certainly be handy to have this functionality built in.

evoxmusic commented 2 years ago

Awesome @timkrins - I will take a deeper look but from what I see it's easily portable. Do you have in mind the limitations of what you did?