search_objects

Documentation Index

Fetch the complete documentation index at: https://dbhub.ai/llms.txt

Use this file to discover all available pages before exploring further.

​

Parameters

• object_type (required): Type of object to search - "schema", "table", "column", "procedure", "function", or "index"
• pattern (optional): Search pattern using SQL LIKE syntax (% for wildcard, _ for single character). Defaults to "%" (match all)
• schema (optional): Filter results to a specific schema
• detail_level (optional): Level of detail - "names" (default), "summary", or "full"
• limit (optional): Maximum results to return (default: 100, max: 1000)

​

Detail Levels

{
  "object_type": "table",
  "pattern": "user%",
  "detail_level": "names"
}

// Returns:
{
  "count": 3,
  "results": [
    { "name": "users", "schema": "public" },
    { "name": "user_profiles", "schema": "public" },
    { "name": "user_sessions", "schema": "public" }
  ]
}

​

Examples

{
  "object_type": "table",
  "pattern": "user%",
  "detail_level": "names",
  "limit": 10
}

​

Pattern Syntax

• % - Matches any sequence of characters
• _ - Matches exactly one character
• Case-insensitive matching

• user% → Matches “users”, “user_profiles”, “user_sessions”
• %_id → Matches “user_id”, “order_id”, “product_id”
• test_ → Matches “test_1”, “test_a” (but not “test_10”)
• %user% → Matches “users”, “user_profiles”, “app_users”

​

Token Efficiency

​

Table and Column Comments

• Table comments appear as the comment field on table results (summary and full levels)
• Column descriptions appear as the description field on each column (full level only)
• Fields are omitted when no comment is set, keeping responses token-efficient

​

Usage Patterns

// Find specific tables by pattern
{
  "object_type": "table",
  "pattern": "user%",
  "detail_level": "names"
}