Graphql-engine: Create indexes using the Console

[eliezedeck]

Hi,

I know you can do that on PostgreSQL, but manually. It would be handy to be able to rely on the Console to do that instead, and also get the up and down migration files along the way.

As far as I know, at this time, you'll have to craft your own SQL query. That is not only time consuming, but very error-prone. Being able to create indexes, even basic ones, right from the Console would help much.

Thanks.

[sn-kaier]

Places where I'd absolutely love to see such a feature in the console would be:

• At add/modify table e.g. below "Unique Keys"
• at Data > Schemas near "Untracked foreign-key relations" as suggestions for foreign keys on one-to-many relations
• at "Query Analysis" for easy query performance improvement (might be more complex, but very nice to have for people with less experience with PostgreSQL).

Additionally it would be handy to see existing indexes in the modify-table section.

[maxcan]

yes please. definitely prefer this to manually creating indices.

[AdityaAnand1]

Any updates on this? Can't believe this hasn't been implemented :(

I just found out that you are forced to do everything via console for migrations and I had to give up my beloved DataGrip, which was a massive productivity hit. And now I find out the console isn't even built completely! Kind of rethinking hasura entirely tbh.

[rikinsk]

@AdityaAnand1 We'll add this soon. In the meantime, you can use the Raw SQL tab to run any SQL command and mark it as a migration.