Does it work with Oracle Autonomous Database?

Yes. Oracle Autonomous Database on OCI has ORDS enabled by default. Use the ORDS URL from your ADB instance (e.g., https://xxxxx.adb.us-ashburn-1.oraclecloudapps.com/ords), your schema name (typically ADMIN), and the admin credentials. The VECTOR type is available on all 23ai-compatible instances.

Can I run arbitrary SQL — not just vector searches?

Yes. The execute_sql_query tool accepts any valid Oracle SQL statement and returns results through ORDS. Add FETCH FIRST N ROWS ONLY to keep payloads manageable. This makes the agent useful for relational queries too, not just vector operations.

Which distance metrics are available for vector search?

Oracle 23ai supports COSINE and EUCLIDEAN (L2) distance metrics natively via VECTOR_DISTANCE. Specify the metric when running a search — cosine is recommended for most text embedding use cases, while L2 works better for image or audio embeddings.

Oracle Vector DB MCP Server

Name: Oracle Vector DB
Availability: InStock
Author: Vinkius

oracle.com/database

Built by Vinkius GDPR ToolsFree

Run vector similarity searches on Oracle 23ai — execute VECTOR_DISTANCE queries, inspect schemas, list vector indexes, and query tables from any AI agent.

Vinkius AI Gateway supports streamable HTTP and SSE.

Works with every AI agent you already use

…and any MCP-compatible client

Oracle Database MCP Server: see your AI Agent in action

AI Agent→Vinkius→Oracle Vector DB

You

Vinkius AI Gateway

GDPR·High Security·Kill Switch·Ultra-Low Latency·Plug and Play

Built-in capabilities (7)

describe_table

Describe table columns and explicit data types including VECTORs

execute_sql_query

WARNING: Output payload size is inherently limited, restrict rows fetched (FETCH FIRST 100 ROWS ONLY) to ensure stability. Execute arbitrary SQL query against the Oracle runtime via ORDS

get_database_version

Get exact Oracle DB Runtime version banner

list_tables

List accessible tables in the current Oracle schema

list_vector_indexes

List specialized AI Vector search indexes (HNSW, IVF) instantiated

table_stats

Get table cardinality and optimizer statistics

vector_search

1, -0.4, 0.5]` against a strict `VECTOR` column natively inside Oracle DB, sorting and fetching the nearest neighbors. Execute Vector similarity search via Oracle 23ai native VECTOR_DISTANCE

What this connector unlocks

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

1. Subscribe to this server
2. Enter your Oracle ORDS URL, Schema, Username, and Password
3. 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

Frequently asked questions

Give your AI agents the power of Oracle Database

Access Oracle Database and 2,000+ MCP servers — ready for your agents to use, right now. No glue code. No custom integrations. Just plug Vinkius AI Gateway and let your agents work.

DETAILS

CategoryIndustry Titans

Cisco Meraki

8 tools

Manage cloud-managed networking via Cisco Meraki — track devices, monitor clients, and audit network health directly from any AI agent.

Zoho CRM Admin

7 tools

Manage Zoho CRM users, roles, profiles, layouts, territories, and tags — complete admin control through conversation.

SEC EDGAR Companies — Ticker Lookup & Company Search

3 tools

Look up any U.S. public company on SEC EDGAR: resolve stock tickers (AAPL, TSLA, MSFT) to CIK numbers, search 8,000+ registered companies by name, and retrieve full SEC registration profiles including SIC industry codes, exchanges, and fiscal year details.

Extracta

10 tools

Automate data extraction via Extracta — process documents into structured JSON, handle AI classification, and audit extraction history directly from any AI agent.

Internet Archive Wayback

10 tools

Check URL archival status, explore capture history, and analyze Wayback Machine data.

TrueFoundry

8 tools

Universal LLM Gateway & ML deployment hub: invoke 1000+ proxy models and manage MCP service instances natively.