Autocomplete doesn't immediately suggest table names

[reteps]

Bug report

For some reason, autocomplete doesn't immediately suggest table names, as I would expect. Only after backspacing a string or hitting escape that doesn't match a schema will it suggest table names.

• I confirm this is a bug with Supabase, not with my own application.
• I confirm I have searched the Docs, GitHub Discussions, and Discord.

Describe the bug

Clipboard-20250906-054535-882.mp4

Potential fix

If this is expected behavior, a setting to disable this and autocomplete at the table level.

To Reproduce

Steps to reproduce the behavior, please provide code snippets or a repository:

1. Type out SELECT * FROM
2. Note that only schemas are suggested
3. Type out some string that doesn't match any schemas
4. Delete that string
5. Note that schemas and tables are suggested

Another way to reproduce:

1. Type out SELECT * FROM
2. Note that only schemas are suggested. For example, typing p will list public.
3. Hit the escape key
4. Note that tables are suggested. For example, typing p now matches table names.

[juleswritescode]

Thanks for the report :)

This is actually expected behavior – it's a best practice to specify schema names in your SQL queries, so we want to encourage this by suggesting schemas first in the FROM clause. The prioritization is small, though.

The reason you're having trouble is that the completion items are currently limited to 50. Even though schemas are prioritized only slightly, if there are more than 50 schemas, there will be no tables in the first completion-item-fetch. In addition, VSCode will only trigger a new completion-item-fetch if what you're typing doesn't match any of those first 50 – but because of fuzzy matching, you're still matching a couple of schemas with Q in their name, so no tables are fetched.

I could raise the limit from 50 to 200, but the problem would persist if you have that many schemas.

It seems to me like this problem is very specific to you (because of your auto generated schemas) so TBH it seems like overkill to provide a setting to disable schema-completion – but if there are more users with the issue, I'll take care of it!

[reteps]

My main question is why there is a discrepancy when I backspace/hit escape.

[reteps]

Regardless, we can work around this.

[reteps]

We were able to work around this ourselves.