Skip to content

Add a way to check db advisors using CLI command #3839

@mateuszbasiak

Description

@mateuszbasiak

Is your feature request related to a problem? Please describe.
Hi! I really like the advisors checks in the app and I wanted to find a way to connect them to my CI flow so that me and my team can ensure we're avoiding all common security and performance issues. Unfortunately, I wasn't able to find any CLI command to achieve this effect easily.

I was able to use manually Splinter query to get the advistor checks, but don't like that I'll have to sync the query manually each time it changes in the Supabase. I'd like to just run some command and be sure that it's always up to date.

Describe the solution you'd like
Ideally, I'd like to have some CLI command allowing me to check my current linked database against common security and performance issues. Something similar to supabse db lint e.g. supabase db check security/performance.

Describe alternatives you've considered
I've noticed there is an deprecated endpoint for getting the advisors data: https://api.supabase.com/api/v1#tag/advisors/get/v1/projects/%7Bref%7D/advisors/performance

However, this seems to work only on hosted projects and I see no way to run this against local instance of supabase. What's the reason it's deprecated and is there a way to run this against local development DB?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions