Oracle Vector DB MCP Connector for Claude
A+Run vector similarity searches on Oracle 23ai — execute VECTOR_DISTANCE queries, inspect schemas, list vector indexes, and query tables from any AI agent.
Bring your Oracle Database 23ai vector capabilities directly into your AI agent workflow. Run VECTOR_DISTANCE similarity searches, inspect table schemas, execute SQL queries, and manage vector indexes — all through natural conversation.
What you can do
- Vector Similarity Search — Execute native Oracle 23ai VECTOR_DISTANCE queries with cosine or Euclidean metrics against any table with VECTOR columns
- Schema Inspection — List all tables in your schema and describe column types, spotting VECTOR-enabled columns for embedding storage
- SQL Execution — Run arbitrary SQL queries against Oracle via ORDS for ad-hoc analysis and data retrieval
- Vector Index Management — List all HNSW and IVF vector indexes instantiated across your tables
- Table Statistics — Get row counts and optimizer stats for capacity planning and query performance tuning
- Version Check — Verify your Oracle runtime version to confirm 23ai vector feature compatibility
How it works
- Subscribe to this server
- Enter your Oracle ORDS URL, Schema, Username, and Password
- Start querying your vector store from Claude, Cursor, or any MCP-compatible client
Who is this for?
- Enterprise data teams — run vector searches against production Oracle databases without context-switching to SQL Developer
- ML engineers — test embedding queries on Oracle 23ai's native vector engine during RAG pipeline development
- DBAs — inspect vector indexes, table stats, and schema configurations through conversation
Related Connectors
Vald MCP
Power your agent with Vald — query, insert, and manage dense vectors on a highly scalable, distributed nearest-neighbor engine.
MongoDB Atlas Vector Search MCP
Manage vector storage via MongoDB Atlas — perform similarity searches, query MQL documents, and audit collections.
Milvus (Open-Source Vector Database) MCP
Manage vector storage via Milvus — perform ANN searches, query scalar entities, and audit collections.
R2R MCP
Equip your AI with direct access to your R2R engine — execute vector searches, run precise RAG queries, and manage your documents.