Set up Scops AI
Connect Scops AI to an OpenAI or Claude model in Settings › AI, and decide which AI features your users get.
Before you begin
- An API key for OpenAI, Azure OpenAI or a compatible endpoint, or for Claude at Anthropic, Microsoft Foundry or Amazon Bedrock. Use a model that calls tools well.
- A network path from the Scops server to the endpoint, usually HTTPS on port 443. The server must trust the certificate of the endpoint. See Ports and network.
- The permissions Manage Settings and Manage AI settings.
Your provider bills the tokens. Scops adds no charge.
Connect a model
Open Settings › AI and click New Profile.
Under Provider, select OpenAI or Claude. Scops fills in the endpoint of the provider.
Optional: type a Name, and change the Endpoint for another host, such as Azure OpenAI.
Paste the API key. Type the Model: the model or deployment name.
Click Test Connection. Scops sends one short question with these settings.
Click Create Profile.
If the test fails, the reason shows under the field to correct. The first profile is the one in use. For a later profile, keep Use it now on to use it at once.
Use, change or delete a profile
| To | Do this |
|---|---|
| Use another profile | Click Use on its row. Scops AI uses it from the next question. |
| Change or rename a profile | Click the profile, change the fields and click Save. A change to the profile in use applies at once. |
| Delete a profile | Click the profile, then Delete Profile. You cannot delete the profile in use. |
Profile settings
| Field | What it does | Default |
|---|---|---|
| Provider | The API that the endpoint speaks. | OpenAI |
| Endpoint | The root of the API. Scops keeps a query string, such as api-version. | The address of the provider |
| API key | Stored encrypted. Scops shows only its first and last four characters. | — |
| Model | The model or deployment name. | — |
| Reasoning | How much the model reasons. OpenAI can turn it Off. Claude goes up to Max. | Auto (medium) |
| Output limit | The most tokens of one answer, reasoning included, 100 to 128,000. | 16,000 |
| API | OpenAI only: Responses or Chat Completions. Auto uses Responses if the endpoint has it. | Auto |
| Limit sent as | OpenAI only: the name of the output limit in the call. Auto finds it. | Auto |
On the Responses API, Scops asks the provider not to store the response. See Privacy and data masking.
Turn AI features on or off
The Assistant switches are the same for every profile. A change applies at once.
| Switch | What it does | Default |
|---|---|---|
| AI assistant | All AI features, for all users. Off hides them, and Scops sends nothing to a model. | On |
| AI-written SQL | Lets Scops AI write its own read-only query on the Scops repository. | On |
| AI-written SQL on monitored databases | Lets Scops AI write its own read-only query on the dictionary and performance views of a monitored database, when no built-in reading has the answer. The query is a SELECT, and it reads only the views of Oracle. It never changes the database, and it never reads an application table or a Diagnostics Pack or Tuning Pack view. See Ask Scops AI for the rules of these queries. | On |
| Reasoning summaries | Keeps the notes of the model on how it reached an answer, in AI Trace. | On |
Keep a database out of Scops AI
Open Policies › Monitoring. AI per database, in Settings › AI, opens it too.
Select the databases. In the bar at the bottom, click Off for AI.
Click Save.
Scops AI then refuses questions about these databases and sends none of their analyses to a model. Answers about many databases still include them.
For one database, you can also use the Ask Scops switch in Edit Database. A new database starts with AI on.
Give users access
Add these permissions to a role. See Build a role.
| Permission | What it opens |
|---|---|
| Use AI | The Ask field in the database bar, and the AI plan of a Radar finding. |
| View Insights | The Ask Scops field on the Databases page, Explain and AI Analysis. |
| View AI Trace | Settings › AI Trace |
| View AI Knowledge | Settings › AI Knowledge |
| Manage AI settings | Settings › AI, with Manage Settings |
All users who can open SQL details can use its two AI buttons. A change card needs the permission of its change.
If Scops AI does not answer
When a question fails, the chat says "AI service is not available. Please try again later."
Open the profile in use and click Test Connection. Correct the field that the message names.
If the test passes, open the question in AI Trace. Error detail shows the reply of the endpoint.
Scops retries a busy endpoint by itself, for rate limits and errors 500 to 504.
Related
Updated November 10, 2026