Skip to Content

Connect Apache Doris to Your AI Agent

Explore database tables and run read-only analytical queries.

4 toolsCustom credential

20,000 free app calls every month(paid services billed separately)

Try a Apache Doris Task

Copy a prompt into your agent with the oo Skill installed. Add your page links and source notes before running it.

oo SkillApache Doris

Query and explore Apache Doris databases with read-only SQL

Explore database tables and run read-only analytical queries.

/oo Apache Doris: List the tables in [database], inspect [table], and summarize [metric] using a read-only SQL query.

Start Working with Apache Doris

  1. Install OOMOL

    Set up oo CLI and the oo Skill in your agent.

    Install OOMOL →
  2. Connect Apache Doris

    Connect a dedicated read-only database account.

    Connect Apache Doris→
  3. Give Your Agent a Task

    Use /oo with the pages to read, the changes to make, and where to save the result.

    Connection Guide →
  • A publicly reachable Apache Doris 2.1+ FE HTTP endpoint.
  • A database account with SELECT_PRIV and its password.
  • Private network endpoints are not supported. Use HTTPS for public endpoints.
  • Queries are limited to one read-only statement; large results are truncated.

Apache Doris Tools

Explore database tables and run read-only analytical queries.

Query and explore Apache Doris databases with read-only SQL

Explore database tables and run read-only analytical queries.

4 tools

Execute Query

Run one read-only SELECT, WITH, SHOW, DESC, DESCRIBE, or EXPLAIN statement against Apache Doris. Writes, INTO OUTFILE, SQL hints, and multiple statements are rejected. Responses are capped at 8 MiB.

doris.execute_query

List Databases

List databases visible to the connected Doris user. Each result row contains a database name.

doris.list_databases

List Tables

List tables and views in a Doris database. Set database here or on the connection.

doris.list_tables

Get Table Schema

Describe a Doris table. Result rows describe fields, types, nullability, keys, defaults, and extra attributes. Set database here or on the connection.

doris.get_table_schema