This release includes the following updates:

• Better concurrency support using 2 new APIs - select_ai.create_pool() and select_ai.create_pool_async(). This creates a shared connection pool for optimal resource sharing

• Support to fetch the UTC timestamp of the next scheduled refresh of Vector Index using vector_index.get_next_refresh_timestamp()

• Vector Index create() API exposes wait_for_completion argument same as the PL/SQL API

• Bug fix in Slack notification agent tool. The channel name should be passed using channel instead of slack_channel

• Bug fix in Email notification agent tool. Missing subject in the API signature

• Support instruction parameter in all tool creation APIs to give a precise set of instructions

• Added more NL2SQL APIs in Session object. Also, select_ai.Session uses the same cursor for the duration of the session. This is logically required to give AI agent feedback on mapped SQL in the same session

• Custom errors to detect empty attributes corresponding to Select AI objects

This is a maintenance release with the following bug fixes and updates:

• Fixed a bug causing ORA-20052: INVALID VALUE FOR TOOL ATTRIBUTE - TOOL_TYPE in methods create_email_notification_tool() and create_slack_notification_tool()
• Fixed a bug causing TypeError in methods agent.enable() and agent.disable()
• profile.run_sql raises select_ai.errors.InvalidSQLError with a detailed error message in case of INVALID SQL generated or NON-EXISTENT tables
• Introduced class level (sync and async) methods to delete Select AI database objects. From usage perspective it felt strange to initialize the Python proxy object and then call delete() on it. With the class level methods, you don't need to initialize the proxy objects just to delete the database object:
  - Agent.delete_agent(agent_name)
  - Profile.delete_profile(profile_name)
  - Task.delete_task(task_name)
  - Tool.delete_tool(tool_name)
  - Team.delete_team(team_name)
  - VectorIndex.delete_index(index_name)

This is a maintenance release with the following updates

• Support for profile.translate()

response = profile.translate(
    text="Thank you", source_language="en", target_language="de"
)

• Bug fix during profile.list() which was failing for dummy profiles
• Multiple bug fixes for profile.add_positive_feedback(), profile.add_negative_feedback() and profile.delete_feedback()
• Enhanced testing coverage for overall stability

This release includes the following updates and enhancements:

• Added support for Select AI Agent. The main classes in this submodule are:

  • select_ai.agent.Tool
  • select_ai.agent.Task
  • select_ai.agent.Agent
  • select_ai.agent.Team

• Support for summarize

  • ai_profile.summarize()

• Support for feedback

  • ai_profile.add_positive_feedback()
  • ai_profile.add_negative_feedback()
  • ai_profile.delete_feedback()

• For consistency, all proxy objects introduce a new fetch API. These are class level methods

  • Profile.fetch(profile_name)
  • Conversation.fetch(conversation_id)
  • Agent.fetch(agent_name)
  • Tool.fetch(tool_name)
  • Task.fetch(task_name)
  • Team.fetch(team_name)

• All proxy objects expose set_attribute and set_attributes() method. This behavior is made consistent.

  • set_attribute(attribute_name, attribute_value) will accept a single attribute
  • set_attributes(attributes) can be used for multiple attributes using the localized attributes class for corresponding object type.

• The grant / revoke privilege are separated from enabling/disabling HTTP access for users. Previously, both operations happened in a single API enable_provider() / disable_provider() which was confusing. Now, we have the following:

  • select_ai.grant_privileges
  • select_ai.revoke_privileges
  • select_ai.grant_http_access
  • select_ai.revoke_http_access

• DBMS_CLOUD_AI_AGENT is added to the list of packages for which we grant / revoke execute privilege

• Added support for Python 3.14

• Added CI support using Github Actions. It runs the complete test suite for Python 3.11, 3.12, 3.13 and 3.14 against ADB 26ai

• HTML documentation https://oracle.github.io/python-select-ai/ with Python docs theme

This release includes the following updates:

• Fixes #6
• Fixed bugs for vector_index get/set attributes
• Handle "no data for prompt" during profile.run_sql to return an empty dataframe
• Handle missing profile when you list vector indexes using vector_index.list()
• Make enable / disable vector index operations idempotent
• Added new samples
• Verified tests for both 19c and 23ai

Select AI for Python v1.0.0

• Create and manage Select AI’s AI profile objects
• Text-to-SQL : Query your database using natural language, whether to generate a SQL query, run or explain that query, or get a narrated response to the results of that query.
• Chat: Use your LLM directly for content generation based on your user prompt—for example, generating custom emails, answering questions, and sentiment analysis—just to name a few use cases.
• Retrieval-Augmented Generation (RAG): Enable LLMs to generate more relevant responses by augmenting your prompt with knowledge from your provided documents
• Automated vector index creation and maintenance: Quickly and easily create a vector index to be used with RAG using data from cloud storage and other sources.
• Results integrated in Python objects: Receive AI-generated results directly into Python data structures, facilitating analysis and integration.
• Chatbot with conversation memory: Create and manage named conversations based on your interactions with the LLM.
• Synthetic data generation: Generate synthetic data for a single table or a set of tables with referential integrity constraints.
• Synchronous and asynchronous invocation: Build applications using Python with either synchronous or the more flexible asynchronous programming style using standalone Python clients. With asynchronous support, the API integrates easily with web frameworks like FastAPI or Flask, enabling real-time AI-driven applications.