Hi,
I’ve been working with VSCode forever and using the AI features sounds interesting at a first glance, however, I cannot for the life of me figure out how to familiarize the AI with my database structure. I’ve tried creating a .cursorrule (I also tried .cursorrules as well as just putting it straight into the settings) file telling it to use a CSV structure I generated using the following statement:
SELECT columns.table_name, column_name, data_type, column_default, is_nullable, udt_name FROM information_schema.columns INNER JOIN information_schema.tables ON columns.table_name = tables.table_name WHERE tables.table_schema = 'public' ORDER BY columns.table_name, ordinal_position
But it’s just completely disregarding it. It does not acknowledge tables, names, does not autoquote (Postgres, case sensitivity) and generally isn’t really that useful. What am I missing to make it useful?