SQL addon for Optimizely CMS 12 updated with new features

First released in 2021 the Sql Studio addon for Optimizely SQL will let you query your Optimizely database from within the edit UI.

Previous features

• Run SQL queries from the comfort of Optimizely CMS UI
• AI for generating queries (can be disabled)
• AI for explaining queries (can be disabled)
• Autocomplete for SQL syntax, table names, and column names, including any custom tables
• Select connection string (i.e. CMS or Commerce)
• Dark mode / light mode
• Save queries for later
• Custom columns with content loading and friendly URL
• Export results to Excel, PDF, CSV
• Use the default connection string, or your own 
• Limit allowed/denied queries with regular expressions
• Available for selected users or groups
• Audit log for traceability

New features

• Support for the new GPT-5 model from OpenAI
• Control the temperature of the LLM model used
• New UI for viewing/deleting saved queries

As before, you can manage saved queries via SQL from the editor’s query window (since they’re stored in the SQL database). However, the newly added UI provides a more convenient option for users who prefer not to work with SQL directly. I'm not sure why they should be using this addon in the first place, but...

The gpt-5 model only supports the default temperature of 1.0, so the previous hard-coded temperature of 0.9 is now configurable, and the new default is set to 1.0.

Getting started

Visit GitHub for all the information you need.

Keep getting to know your database, but be careful!

Good luck!