Hello! First of all, this is a fantastic project. Thanks for making it, and for making is open source 😄

I have a feature request that I'd like your opinion on. I can open the PR and do the work, I just want to make sure you're on board for it. Currently to use the AI feature, you add a schema and query to a prompt and do the openAI (generously) call yourself. I like that all my tables are already injected into the prompt.

Let's say I have chatGPT premium, I want to paste the prompt into it and maybe carry on the conversation on in chatGPT.
So it'd be nice if there was a button to copy the prompt, already formatted with my table schemas, to paste into chatGPT.

Currently it's still possible of course, just inspect the request in the network tab and reformat it. This is just a little feature.

Hi, Firstly it is great job! we needed it too much!

The issue is I have tables and views from tables but when I wanna export SQL views shown as tables.

• suggested by @emileond,

I have a self-referencing foreign key on one of my tables (concretely category.parent_id),
the diagram shows it perfectly, but exporting to types fails (memory leak?).

When you do an export of a table schema and one of the columns is of type text array, the array type is lost and it is left as simply array

When using the script, we receive a syntax error with the word ARRAY

Example:

create table candidates ( id uuid default uuid_generate_v4() primary key, created_at timestamp default now(), name text, email text, phone text, entry text, tag text, status text, quizzes json, file text, "level" text, profilesJobs ARRAY, notes ARRAY );

When exporting types, it would be nice to make sure they are alpha-sorted so the diff between 2 versions are more readable.
Also, wouldn't it be better to export them all by default?

Hey, thanks for the tool!

We would like to use this for our internal documentation, and it would be awesome if our developers won't have to type in the url and anon key every time. Would it be possible to add these to the query params?

Best
Philipp

Hi, I have a project that uses numerous schemas (other than just public) and believe that there should be support for schemas that aren't named 'public'.

Can only zoom in and out, how do you pan left/right?

When toggling dark mode to light mode, the relationship lines remain white, and therefor are invisible.

Thanks for this really cool app! :)

While I like a lot the default dark theme, I think it would be cool to be able to switch to a light theme, at least for taking the screenshot of the diagram to make it printable.

Thanks!

In abscense of a mouse, it is not possible to pan in the app's canvas using the laptop's touchpad.

I am using an HP laptop (Winx64). Possible solution: Spacebar+LeftClick or Shift+LeftClick.

I have a subjects array column in my table, and when I tried to export types I got
subjects: any // type unknown; instead of e.g.
subjects: string[]

It would be nice to also display the description of the columns in the visualization. It could be a tooltip after hover.

If I have circular foreign key constraints, the app freezes after clicking 'Export Types' or 'Export SQL'.

I have 10 tables and so many columns.
I can export type on my previous app.

Description

In one of my projects that used supabase-schema to generate the SQL scripts, many of fields use camelcase, hence the generated script by default does not work since Postgres require camelcase/uppercase fields to be included in double quotes. e.g. sourceRepo needs to be "sourceRepo"

Example Screenshot

Current fields that are generated

Running the above script will create the fields all in small caps, and all the calls to supabase DB from app will fail due to wrong schema.

Suggested solution

Hence, this issue is requesting for the generated script to include quotes.
P.S. I can also work on this if u can include hacktoberfest label to this 😄

create table questions_new_free_assessment (
  id bigint not null primary key,
  inserted_at timestamp default now() not null,
  updated_at timestamp default now() not null,
  question_text text not null,
  question_description text,
  **type public.valid_question_type not null,**
  choices text[],
  answer text,
  priority integer
);

Here the the column type is defined as a custom struct type of the valid_question_type but its not exported in the sql or ts

I have a column with SQL:
latitude numeric(8, 6) null
However, the type does not get recognized for TS export:
latitude?: any // type unknown;

Would love to see: Domains, Enum Types and Indexes in the SQL output at least,

Can you please make a schema maker where we just the diagram and your website automatically generates the database for us. Isn't it possible.