List configured OceanBase MCP profiles with redacted settings.

Check profile, policy, TLS, HTTP, and production hardening settings.

Check local OpenCode config, OceanBase agent, and query skill files for the current project.

Return the recommended read-only OpenCode workflow, safety rules, and MySQL/Oracle notes.

List supported tool groups, tool versions, active compatibility mode, and read-only limits.

Clear in-memory metadata cache entries for the active profile, optionally scoped by schema or table.

Return profile-scoped metadata cache settings and counters without exposing cached content.

Inspect current database grants and report whether the account appears read-only.

Verify the configured OceanBase connection.

Explain whether a SQL statement is allowed and which read-only or access-policy checks apply.

Preview policy, sensitive-column, and EXPLAIN risk for a read-only SQL statement without executing the target query.

Run a strictly read-only SQL statement against OceanBase.

Run a strictly read-only SELECT/WITH query with server-side pagination.

Create an in-memory read-only query context for follow-up paging, refinement, and summarization.

Return a read-only query session context without exposing stored parameter values.

Close an in-memory query session for the selected profile.

Run the next page for a read-only query session without bypassing row, timeout, output, or policy limits.

Run the previous page for a read-only query session without bypassing row, timeout, output, or policy limits.

Build a refined read-only SELECT from a query session using structured columns, filters, ordering, and pagination without executing it.

Summarize already returned query rows without reading the database.

Compare two already returned query results without reading the database or storing row values.

Generate a bounded Markdown or CSV preview string from already returned rows without writing files.

Run EXPLAIN for a strictly read-only SQL statement.

Run EXPLAIN for a strictly read-only SQL statement and return evidence-based plan findings.

Generate a read-only SQL performance advisory report from EXPLAIN, table statistics, and index metadata.

Build a parameterized read-only SELECT from validated table, columns, filters, ordering, and pagination without executing it.

Generate read-only SQL templates from policy-filtered table metadata without executing them.

Generate scenario-based read-only SQL examples from policy-filtered table metadata without executing them.

Read recent rows from an allowed table using an explicit or metadata-detected time column with safe pagination.

List schemas/databases visible to the current OceanBase user, filtered by access policy.

List tables visible to the current OceanBase user, filtered by access policy.

Return column metadata for an allowed OceanBase table.

Return a compact, policy-filtered schema map with table summaries, key fields, and relationship hints.

Generate a bounded JSON or Markdown data dictionary from visible table and column metadata.

Find foreign-key and conservative naming-based relationships for an allowed OceanBase table.

Generate bounded JSON, Markdown, or simple HTML data dictionary output from visible metadata.

Search schemas, tables, columns, and comments, filtered by access policy.

Find visible candidate tables from a business term using glossary, catalog metadata, comments, and relationship evidence.

Search visible schemas, tables, columns, comments, and business glossary entries with confidence and evidence.

Search optional business terms mapped to allowed OceanBase schemas, tables, and columns.

Find visible columns across tables by name, comment, data type, table pattern, or business term.

Return policy-filtered table columns and types for one table.

Return native or structured DDL metadata for an allowed OceanBase table.

Return table-level optimizer statistics and metadata counts for an allowed OceanBase table.

Return a compact table summary with inferred purpose, key fields, relationship hints, and query entry points.

Return indexes for an allowed OceanBase table.

Return constraints for an allowed OceanBase table.

Return partition metadata for an allowed OceanBase table.

Return a small, policy-filtered sample from an allowed table. Sensitive-looking fields are always masked.

Return the common read-only table context needed for SQL drafting and data inspection.

List policy-filtered Oracle object metadata such as views, sequences, synonyms, procedures, functions, and packages.

Return bounded, policy-filtered metadata for one Oracle view, sequence, synonym, procedure, function, or package.

Detect likely create, update, and business time columns from visible table metadata.

Detect likely status, type, channel, region, flag, and category columns from visible table metadata.

Capture a bounded metadata-only OceanBase snapshot for later offline diff and impact analysis.

Compare two metadata-only snapshots and return evidence-based structural changes.

Analyze which indexed project SQL snippets are impacted by a metadata snapshot diff.

Summarize metadata diff impact using optional SQL usage index and business glossary evidence.

Generate a Markdown or simple HTML metadata change report from diff and impact evidence.

Compare two visible tables by columns, indexes, constraints, and partitions.

Compare two visible schemas by table list and bounded per-table metadata differences.

Convert read-only SQL between OceanBase MySQL and Oracle modes with documented limitations.

Explain a SQL error with policy context and visible metadata hints without executing the SQL.

Lint read-only SQL for policy, dialect, pagination, ordering, sensitive fields, and optional EXPLAIN risk without returning data.

Rewrite SELECT/WITH SQL into a safer read-only form without executing it.

Find project SQL usages from a static SQL usage index without executing SQL or reading project files.

Validate a pasted read-only SQL snippet for policy, dialect, pagination, plan risk, and visible table or column metadata.

Explain a read-only SQL snippet from text or a local project file without executing it.

Generate bounded JSON or Markdown documentation for a SQL snippet without executing the target query.

Generate read-only table and column context for a MyBatis mapper, SQL file, or explicit table.

Find unknown tables or columns in SQL and return visible metadata-based candidates without executing the SQL.

Prepare candidate tables, fields, read-only SQL drafts, and safety previews from visible metadata without executing the target query.

Return a bounded table-level profile with metadata counts, key fields, time/status fields, and sampled null overview.

Return bounded, policy-filtered column profiles for an allowed OceanBase table.

Return bounded top-value distribution for one allowed column, with masking and sample limits enforced.

Run bounded read-only data quality checks for nulls, duplicate key risk, dimensions, and time columns.

Generate bounded JSON or Markdown documentation for one visible table without returning sample values.

Generate bounded JSON or Markdown documentation for visible tables in one schema.

Generate bounded onboarding documentation from visible OceanBase metadata and optional business glossary hints.

Explain visible relationship evidence between two OceanBase tables without inventing missing relationships.

Generate Mermaid and JSON ER metadata from allowed OceanBase table metadata and relationships.

Generate Markdown, PlantUML, and DOT documentation from allowed ER metadata and relationship evidence.

Generate a local entity-focused ER diagram from a business term or table, with Mermaid, JSON, and optional HTML.

Plan local ER HTML export commands for large OceanBase schemas without returning large inline HTML.

Generate a self-contained HTML ER diagram from allowed OceanBase metadata and relationship evidence.