* Realtime Inspector adjustments
* Leave just insert and select
* add new realtime authz docs link (#27755)
* fix: remove using from insert policies
* Add prop to differentiate db from realtime
* Update toast
---------
Co-authored-by: Wen Bo Xie <5532241+w3b6x9@users.noreply.github.com>
Co-authored-by: Wen Bo Xie <wenbo.xie3@gmail.com>
* Add queries and mutations for realtime channels.
* Change the layout, add a link for policies and modal for creating a channel.
* Add a page for policies.
* Add templates for realtime tables.
* Fix the spacing in the PolicyDetails component. Add better types.
* Pass templateData to the template generating functions.
* Various CSS fixes.
* Add components for rendering the realtime policies page.
* Fix the editing policy flow.
* Fix refetching when adding or deleting policies.
* Minor various fixes.
* Remove an old console.log.
* More fixes for templates.
* Make the realtime policies open by default when clicking on realtime.
* Update the realtime policy templates.
* Use a dropdown button for the three types of policies.
* Fix a copy-paste mistake.
* Fix icons.
* Fix the toast.
* Clean up the previous components.
* Clean up more unneeded code.
* Remove templateData prop.
* Remove unneeded queries and mutations.
* More cleanup.
* Reuse the components from the Auth Policies.
* Minor fixes for the new components.
* Add a feature flag for AuthZ.
* Revert some changes.
* Fix a build error.
* Fix all definitions.
* Fix an issue with copying large lines which from templates which are word-wrapped.
* Addressed various comments by Joshen.
* Revert the UI changes in the Policy Editor.
* Update the template names.
* Small style fix
---------
Co-authored-by: Joshen Lim <joshenlimek@gmail.com>
* chore: deprecate old files. add new one with first story
* init multi select
* docs
* Update multi-select.mdx
* deprecation notices
* Delete MultiSelect.stories.tsx
* Make the useUrlState typesafe.
* Remove the dependency on the valtio state for the Ai Policy Panel.
* Remove the valtio state and use the URL query state for keeping selected schema and filter string.
* Update GridHeaderActions component to include schema parameter in policy search URL
---------
Co-authored-by: Alaister Young <a@alaisteryoung.com>
* Fix 'Fix with assistant' for RLS editor
* Code editor height will consider line wraps + support right click format query
* Fix content height and line count on mnount rls ediutor
* Update comment
* check and load val from search
* Fix
* Add scroll area for table selection in RLS editor
* Further contextualize RLS templates on hover
* Fix RLS feature preview with the new UI
---------
Co-authored-by: Joshen Lim <joshenlimek@gmail.com>
* Midway checking on hybrid rls assistant
* Demo
* Midway
* Polish + hook up everything for policy creation
* Temp fix for open in sql editor
* Resolve conflicts
* Support updating policies with new hybrid ui
* Fix generateQuery for altering policies
* Update to support feature preview
* Fix spelling lint
* Addressing small bugs
* Fix
* Clean upo
* Add new MultiSelectV2 in ui-patterns, use in RLS editor
* More clean uo
* Fix RadioGroupLargeItem label cursor state when disabled
* Lint lowercase sql
* Refactor and remove the CreateFunctionStore.
* Fix a duplicate key in the functions table.
* More fixes for the create-function form.
* Add excluded schemas to schema selector.
* Cleanup the createFunction code after the merge.
* Remove unneeded wrapper fragments.
* Minor fixes for the FormItemLayout stories.
* Refactor the CreateFunction panel using the new FormItemLayout.
* Revert the migration to use FormItemLayout. Will revisit later.
* Add a CSS class for popover content width to match its trigger width. Use it on the schema selector.
* Replace all listboxes with selects.
* Fix the comments.
* Switch to FormItemLayout wherever possible.
* Move the createFunction file to its own folder.
* Refactor the panel to use shadcn components: Sheet, SheetContent and SheetHeader.
* Add showClose prop to the Sheet component.
* Add function editor and a feature to maximize/minimize the code editor.
* Some fixes
* Add sameWidthAsTrigger to the popover component.
* Fix the icon size.
---------
Co-authored-by: Jonathan Summers-Muir <MildTomato@users.noreply.github.com>
Co-authored-by: Joshen Lim <joshenlimek@gmail.com>
* Connect UI Prisma DATABASE_URL param to be transaction mode - port 6543
* Connect UI Prisma DIRECT_URL param to be pooler string with session mode - port 5432
* Change checking if read replicas can deployed from if PITR addon is available, to if walg is enabled
* Fix RLS assistant not surfacing error
* Update]
* fix
* Add a API endpoint for generating queries for the SQL editor.
* Merge all multiline props.
* Add a new component for diff actions.
* Copy components for the AI panel.
* Add useChat hook.
* Add a feature preview for the this feature. The preview is dependent on the feature flag.
* Reorder the nesting in the SQL editor to accomodate the AI assistant.
* Try to fit both AI assistants in the SQL editor, available via a feature preview.
* Refactor the SQL editor to make the diff work correctly in all cases.
* Minor fixes for the old AI feature.
* Fix the debug functionality to work with both assistants.
* Fix some copy-paste leftovers.
* Remove unneeded code.
* Make the icons softer.
* Fix the name of the panel component.
* Fix console.logs.
* Add overflow to the AI assistant.
* surface opt in config in ai settings button
* Skip diffing if editor is empty
* Add selected state when selecting a message to insert/replace code
* Add sample prompts
* Add SQL ai dislaimer when replacing code
* Light mode action bar nudges
* Add text for the feature preview.
* lang nudges
* Hide the command suggestions for now.
* Set the discussion url to undefined.
* Don't add the disclaimer twice.
---------
Co-authored-by: Joshen Lim <joshenlimek@gmail.com>
Co-authored-by: Terry Sutton <saltcod@gmail.com>
* Add templates to RLS assistant
* Update button
* lint
* Chore/rls assistant iteration templates styling (#21459)
* Update index.tsx
* update icon pack
* add new classes
* expose hover card
* add slight shadow to scroll area
* monaco editor updated
* tabs border-b updated
* message styling updated to use circle AI icon
* templates side panel updated to use new tailwind classes and ScrollArea
* Updated tab label to "Assistant" and adjusted background colors
* header updated to use simpler open/close button
* divide-y styling added to chat
* fix tabs bg state
* shadcn tooltip updated to use correct bg color and added default delay duration
* updated styling of codeblocks in chat
* updated open / close button. also added a tooltip
* divide border styling
* add 'slide in' animation option for Hover Card
* update code block
* switch to Card Button
* Update CardButton to expose props and allow any props to be applied
* init
* Apply suggestions from code review
* Add entry step when clicking on create new policy for rls ai
* templates code replacement state highlight selected template
* Ai message code replacement state highlight selected message
* Opt to leave templates panel open
* Fix templates to use template name in policy sql
* Fixes
* fix
* Remove unused imports
---------
Co-authored-by: Jonathan Summers-Muir <MildTomato@users.noreply.github.com>
* Start
* Refactor code and remove unused imports
* Refactor SchemaFlowHandler and UserChat components
* Refactor code and remove unused files
* Refactor Thread component and remove CurrentThreadName import
* Remove oldest_messages view from supabase.ts
* Refactor supabase.ts file
* Hook up loading state ChatInput component and remove old route handlers
* Add updated prompt
* Refactor chat form component and remove unused code
* Make the suspense work when fetching messages.
* Small refactor in the chat assistant form component.
* Experimenting with streaming responses. WIP.
* Move all components to thread_id/message_id folder.
* Massive refactor but uses Nextjs app router properly.
* Add a conditional submit which is used if the user haven't been logged in.
* Add a typecheck command to db-new app.
* Minor fixes.
* Bunch of minor fixes.
* Clean up more code.
* Refactor the AssistantChatForm to use the new React forms features.
* Run fitView after 50 milliseconds because it didn't run in some cases.
* Style and flow nudges
* Prettier
* Delete old file
---------
Co-authored-by: Ivan Vasilov <vasilov.ivan@gmail.com>
* Add highlight for new rls assistant
* Optional close function
* Update UI
* Update button text
* Small style fixes on rls assistant ui
* Small style fixes
* Add cta to revert feature preview in rls assistant
* Fixes and ensure RLS assistant CTAs do not overlap into storage policies
---------
Co-authored-by: Joshen Lim <joshenlimek@gmail.com>
* feat: track rls ai editor usage
when user accepts consent, we track when rls editor:
ai suggestion accepted
ai suggestion discarded
copy code from code block in ai assistant
apply changes from code block in ai assistant
when question is asked in ai assistant
when sql has and error and ai debugger was requested
* fix: add asking part and change to past tense
* chore: add fix with assistant tracking
* fix: deploy error and merge master
* fix: action label fixed at queryerror
* refactor: ai sql logic to common package
* feat: ai sql tests
* feat: test rls policy ai chat assistant
* refactor: jest env loading
* feat(ai): improve sql title and description quality
* fix: ai message role type
* Move the new files to a separate package.
* Remove a forgotten console.log.
* Migrate the tests to use snapshots and commit the snapshots.
* Separate the functions which require edge runtime to be exported via /edge subpath.
* Bust the turbo cache when one of the deps has been rebuilt.
* chore: fix package main/type references
* fix: package lock out of sync
* fix: ai sql debugging to fix typos
---------
Co-authored-by: Ivan Vasilov <vasilov.ivan@gmail.com>
* Add database policies RQ and shift all usage of policies from pg meta mobx to RQ
* Deprecate and remove policies store from pg meta mobx store
* Fix policies not showing by table and schema
* Update create policy mutation body
* Add some more instructions to the AI Editor.
* More updates to the suggestion instructions.
* Add spacing to policy details
* Monaco settings
* Copy changes to check when clicked
* Spelling
* More instructions for the AI.
* Make the error panel wrap text. Calculate the height of the editor dynamically.
* Add a comment.
---------
Co-authored-by: Terry Sutton <saltcod@gmail.com>
* Update the wording on few places.
* Update instructions for AI when generating policies.
* Format the SQL in the suggestion blocks to have uppercased keywords.
* Add padding before each code block.
* Word wrap the code in the diff editor.
* Remove unused component.
* Remove the added instruction.
* Add tab instructions.
* Add vercel/ai. Commit additional next types.
* Add a API route in /app for streaming responses.
* Make the components work with streaming response.
* Add a dummy page to /app folder to fix a linking bug.
* Fix the dummy page.
* Fix the dummy page again.
* Add an empty layout to the app folder.
* Make the code snippets in the chat read-only.
* Remove queries and mutations for suggest.
* Reset the chat when closing the panel.
* Make the AI instructions a bit better.
* Don't render empty code blocks.
* Try to use remark for rendering the code. Style fixes for CodeBlock in AI assistant panel.
* Fix the styling of the definitions when sending them to OpenAI.
* Fix the css styling of the messages and code blocks.
* Move the suggest API route from app to pages folder.
* Revert the change for app API routes.
* Make the API route look like the rest of the API routes.
* Use Pre instead of Code because the <code> tags aren't working if between spans.
* Minor leftovers.
* Revert to using app route handlers.
* Change the wording on the diff header.
* Add nextjs types.
* Fix a missing import.
* Move AssistantChatForm back to db-new.
* Fix a build error.
* Rename the suggest route to assistant.
* Fix Joshen's comments.
* Fix broken URLs
* Limit realtime inspector to only the public schema as any other schema won’t work out of the box due to missing permissions
* Hide copy to clipboard for realtime message panel timestamp
* Add placeholder value for sending test message and fix sending test message to be sent as JSON
* Change channel name input to form
* Add join channel empty state
* Update copy writing
* Shift broadcast, presence, db changes toggle to filter message popover
* Add cursor-default
* Small style fix
* Fix toggles
* Address some feedback
* Fix the impersonation UI.
---------
Co-authored-by: Ivan Vasilov <vasilov.ivan@gmail.com>
* Send policy definition to AI when editing a policy
* Only send entity definitions if opted into AI for RLS ai assistant
* Scaffold collapsible policy details
* Update comment
* Update
* Update height
* fix messages sorting
* Have rls ai assistant sit in feature preview + shown via feature flag
* Support editing existing policy in new AI assistant panel
* Beef up feature preview
* Shift AI settings modal to components/ui and add AI settings to RLS AI assistant panel
* Update apps/studio/components/interfaces/App/FeaturePreview/RLSAIAssistantPreview.tsx
Co-authored-by: Copple <10214025+kiwicopple@users.noreply.github.com>
* Update apps/studio/components/interfaces/App/FeaturePreview/RLSAIAssistantPreview.tsx
Co-authored-by: Copple <10214025+kiwicopple@users.noreply.github.com>
---------
Co-authored-by: Copple <10214025+kiwicopple@users.noreply.github.com>
* Add two more sizes to the Panel component.
* Add alias for the older openai-api library. The new one is added under the openai name.
* Add API routes
* Add components for the new AI RLS panel.
* Bunch of changes to the AI Policy Editor.
* Add a button for opening the new Policy Editor.
* Add a feature flag for the new editor.
* Add a confirmation modal when closing the panel.
* Fix leftover data when closing the panel.
* Make the copy button work.
* Add the next/swc packages to package-lock.json.
* Merge master
* Scaffold debug sql in rls editor
* Small improvements to policy chat
* Hook up debug to ai assistant panel
* Improve debug UX
* Add debug request badge
* Some styling fix
* Small styling fix
* Another small styling fix
* Shift create new policy ai button + fix error stylign with code editor height
* Add tooltips to apply changes and copy code from assistant message
* Hide assistant button is not platform
* Small lint
* Add default error handlers to all AI RQ mutations
* Small fix
* Remove IS PLATFORM check for rls assistant
* Add placeholder to RLS code editor
* Fix diff + rls code editor
* Add placeholder message after sending prompt
* Small style
* RLSCodeEditor hit tab if empty to populate placeholder text
* Light mode nudeges
* Update logic for when confirmation close modal should show
* Set render overview ruler as false for rls diff editor
* improve chat UX to make it smoother (thank you alaister for your help 🙏)
* Dynamically do keepPreviousData
* Gracefully handle errors for add prompt
* Use animated ai icon while message is loading
* using Sheet component
* Address commernts
* Bit more improvements
---------
Co-authored-by: Joshen Lim <joshenlimek@gmail.com>
Co-authored-by: Jonathan Summers-Muir <MildTomato@users.noreply.github.com>
