Uploaded July 2026 | Updated September 2026, 2 weeks ago
In this Autonomous AI Database Learning Lounge session, the Oracle Autonomous AI Database and Spatial PM teams shared how to use documentation-backed AI Skills to generate trustworthy Oracle Spatial SQL. They presented how Oracle Database Skills help AI assistants move beyond plausible-looking answers by grounding them in curated Oracle guidance, examples, version notes, and common mistake patterns. Through spatial query examples and live demonstrations, the difference between guessed SQL and correct, index-aware Oracle SQL were shown.
Register for our monthly sessions and watch recordings at oracle.com/goto/adb-learning-lounge
Slides for this session at: oracle.com/a/otn/docs/adbll/adbll_spatial_thinking_adb.pdf
=== Links from the Session ===
Agent Skills Overview: thatjeffsmith.com/archive/2026/03/agents-skills-load-csv-to-new-oracle-tables-via-sqlcl-mcp
Having a go with 100+ new AI Skills for Oracle AI Database by Jeff Smith: thatjeffsmith.com/archive/2026/03/having-a-go-with-100-new-ai-skills-for-oracle-ai-database
Oracle Skills GitHub repo - App Dev specific skills: github.com/oracle/skills/tree/main/db/appdev
AI For You Newsletter by Kay Malcom on LinkedIn: linkedin.com/newsletters/ai-for-you-7424468042824437760
AI agents know SQL. Oracle Database Skills teach them Oracle: blogs.oracle.com/developers/ai-agents-know-sql-oracle-database-skills-teach-them-oracle
Getting started with our MCP Server for the Oracle Database: thatjeffsmith.com/archive/2025/07/getting-started-with-our-mcp-server-for-oracle-database
Introducing MCP Server for the Oracle Database: blogs.oracle.com/database/introducing-mcp-server-for-oracle-database
Using the Oracle SQLcl MCP Server: docs.oracle.com/en/database/oracle/sql-developer-command-line/26.1/sqcug/using-oracle-sqlcl-mcp-server.html
LiveLabs: Exploring SQLcl MCP Server: livelabs.oracle.com/ords/r/dbpm/livelabs/view-workshop?clear=RR,180&wid=4285
Docs on Autonomous AI Database MCP Server: docs.oracle.com/en/cloud/paas/autonomous-database/serverless/adbsb/mcp-server.html
Blog on Autonomous AI Database MCP Server: blogs.oracle.com/machinelearning/connecting-codex-to-enterprise-data-with-oracle-autonomous-ai-database-mcp-server
=== Links about Autonomous Database ===
Our Get Started Page is the right place to start: oracle.com/autonomous-database/get-started
Autonomous AI Database Free Container Image: "docker pull container-registry.oracle.com/database/adb-free:latest"
Autonomous AI Database for Developers: docs.oracle.com/en-us/iaas/autonomous-database-serverless/doc/autonomous-database-for-developers.html
All Autonomous AI Database Hands-on Labs: livelabs.oracle.com/adb
ADB LinkedIn Newsletter: bit.ly/li-adb-news
Join our Group on LinkedIn: linkedin.com/groups/13819289
Ask questions by joining our External Slack workspace and search for the 'oracle-autonomous-database' channel: bit.ly/odevrel_slack
== Outline ==
Why AI assistants can produce confident but subtly incorrect Oracle SQL
What Oracle Database Skills are and how AI tools use them as grounding context
Why Oracle Spatial is a strong test case for grounded AI assistance
Live before-and-after demo: natural language to Oracle Spatial SQL without and with a Skill
Spatial essentials: SDO_GEOMETRY, R-tree indexing, metadata, and spatial operators
Choosing between SDO_WITHIN_DISTANCE, SDO_NN, and SDO_RELATE
Using the Autonomous AI Database MCP server to inspect schemas, run queries, validate results, and self-correct
How the Skills pattern extends beyond spatial to other Oracle AI Database development tasks
== Video highlights ==
00:00 Welcome and session opening
01:30 Session title and speakers
02:00 Agenda and session topics
04:00 What are AI Skills?
06:00 Why AI Skills are useful
08:00 Oracle Database Skills and the Skills repository
10:00 Introducing the spatial data use case
12:00 Spatial data types: points, lines, and polygons
14:00 Oracle Spatial and SDO_GEOMETRY
16:00 Common spatial SQL mistakes
18:00 The easy way: using Codex with Oracle Database Skills
20:00 Using Cursor with Oracle Database Skills
22:00 What is the Model Context Protocol (MCP)?
24:00 Connecting an AI assistant to the Autonomous AI Database MCP Server
26:00 Live demo: asking an AI assistant to generate spatial SQL
29:00 Validating the generated SQL and correcting mistakes
32:00 Working with spatial metadata and indexes
35:00 Choosing spatial operators: SDO_WITHIN_DISTANCE, SDO_NN, and SDO_RELATE
38:00 Using the MCP Server to inspect schemas and run queries
41:00 Reviewing query results and self-correction
44:00 Tips for using Oracle Database Skills effectively
46:00 Session resources and links
48:00 Open Q&A
53:00 Final thoughts, upcoming sessions, and replays
56:00 Thanks and closing
In this Autonomous AI Database Learning Lounge session, the Oracle Autonomous AI Database and Spatial PM teams shared how to use documentation-backed AI Skills to generate trustworthy Oracle Spatial SQL. They presented how Oracle Database Skills help AI assistants move beyond plausible-looking answers by grounding them in curated Oracle guidance, examples, version notes, and common mistake patterns. Through spatial query examples and live demonstrations, the difference between guessed SQL and correct, index-aware Oracle SQL were shown.
Register for our monthly sessions and watch recordings at oracle.com/goto/adb-learning-lounge
Slides for this session at: oracle.com/a/otn/docs/adbll/adbll_spatial_thinking_adb.pdf
=== Links from the Session ===
Agent Skills Overview: thatjeffsmith.com/archive/2026/03/agents-skills-load-csv-to-new-oracle-tables-via-sqlcl-mcp
Having a go with 100+ new AI Skills for Oracle AI Database by Jeff Smith: thatjeffsmith.com/archive/2026/03/having-a-go-with-100-new-ai-skills-for-oracle-ai-database
Oracle Skills GitHub repo - App Dev specific skills: github.com/oracle/skills/tree/main/db/appdev
AI For You Newsletter by Kay Malcom on LinkedIn: linkedin.com/newsletters/ai-for-you-7424468042824437760
AI agents know SQL. Oracle Database Skills teach them Oracle: blogs.oracle.com/developers/ai-agents-know-sql-oracle-database-skills-teach-them-oracle
Getting started with our MCP Server for the Oracle Database: thatjeffsmith.com/archive/2025/07/getting-started-with-our-mcp-server-for-oracle-database
Introducing MCP Server for the Oracle Database: blogs.oracle.com/database/introducing-mcp-server-for-oracle-database
Using the Oracle SQLcl MCP Server: docs.oracle.com/en/database/oracle/sql-developer-command-line/26.1/sqcug/using-oracle-sqlcl-mcp-server.html
LiveLabs: Exploring SQLcl MCP Server: livelabs.oracle.com/ords/r/dbpm/livelabs/view-workshop?clear=RR,180&wid=4285
Docs on Autonomous AI Database MCP Server: docs.oracle.com/en/cloud/paas/autonomous-database/serverless/adbsb/mcp-server.html
Blog on Autonomous AI Database MCP Server: blogs.oracle.com/machinelearning/connecting-codex-to-enterprise-data-with-oracle-autonomous-ai-database-mcp-server
=== Links about Autonomous Database ===
Our Get Started Page is the right place to start: oracle.com/autonomous-database/get-started
Autonomous AI Database Free Container Image: "docker pull container-registry.oracle.com/database/adb-free:latest"
Autonomous AI Database for Developers: docs.oracle.com/en-us/iaas/autonomous-database-serverless/doc/autonomous-database-for-developers.html
All Autonomous AI Database Hands-on Labs: livelabs.oracle.com/adb
ADB LinkedIn Newsletter: bit.ly/li-adb-news
Join our Group on LinkedIn: linkedin.com/groups/13819289
Ask questions by joining our External Slack workspace and search for the 'oracle-autonomous-database' channel: bit.ly/odevrel_slack
== Outline ==
Why AI assistants can produce confident but subtly incorrect Oracle SQL
What Oracle Database Skills are and how AI tools use them as grounding context
Why Oracle Spatial is a strong test case for grounded AI assistance
Live before-and-after demo: natural language to Oracle Spatial SQL without and with a Skill
Spatial essentials: SDO_GEOMETRY, R-tree indexing, metadata, and spatial operators
Choosing between SDO_WITHIN_DISTANCE, SDO_NN, and SDO_RELATE
Using the Autonomous AI Database MCP server to inspect schemas, run queries, validate results, and self-correct
How the Skills pattern extends beyond spatial to other Oracle AI Database development tasks
== Video highlights ==
00:00 Welcome and session opening
01:30 Session title and speakers
02:00 Agenda and session topics
04:00 What are AI Skills?
06:00 Why AI Skills are useful
08:00 Oracle Database Skills and the Skills repository
10:00 Introducing the spatial data use case
12:00 Spatial data types: points, lines, and polygons
14:00 Oracle Spatial and SDO_GEOMETRY
16:00 Common spatial SQL mistakes
18:00 The easy way: using Codex with Oracle Database Skills
20:00 Using Cursor with Oracle Database Skills
22:00 What is the Model Context Protocol (MCP)?
24:00 Connecting an AI assistant to the Autonomous AI Database MCP Server
26:00 Live demo: asking an AI assistant to generate spatial SQL
29:00 Validating the generated SQL and correcting mistakes
32:00 Working with spatial metadata and indexes
35:00 Choosing spatial operators: SDO_WITHIN_DISTANCE, SDO_NN, and SDO_RELATE
38:00 Using the MCP Server to inspect schemas and run queries
41:00 Reviewing query results and self-correction
44:00 Tips for using Oracle Database Skills effectively
46:00 Session resources and links
48:00 Open Q&A
53:00 Final thoughts, upcoming sessions, and replays
56:00 Thanks and closing
