Skip to main content

​
Overview

Before loading or querying data, it helps to understand what is already in your database. The discovery commands introspect any connected SQLite, PostgreSQL, or ClickHouse database and build a detailed structural catalog — tables, columns, types, indexes, foreign keys, row counts, and sample data. Optionally enrich the catalog with LLM-generated descriptions for instant context. Discovered catalogs are saved locally and can be browsed anytime — useful for AI agents that need database context without manual documentation.

​
Discover Database Structure

Run discovery against any configured connection:
This introspects the database and outputs:
  • Tables with row counts
  • Columns — name, type, nullability, defaults, primary keys
  • Indexes — name, columns, uniqueness
  • Foreign keys — source and target columns
  • Sample data — first rows from each table
  • Read-only status — auto-detected (PostgreSQL replicas, read-only filesystems, ClickHouse readonly setting)
The result is automatically saved as a catalog for future reference.
Discovery works with SQLite (via PRAGMAs), PostgreSQL (via information_schema and pg_catalog), and ClickHouse (via system.tables and system.columns). Note: ClickHouse does not support foreign keys, so FK discovery returns empty results.

​
LLM Enrichment

Add human-readable descriptions to your catalog using an LLM:
Requires the LLM extra: pip install "anysite-cli[llm]" and a configured LLM provider (anysite llm setup).
LLM enrichment adds four layers of context: This context is saved in the catalog and can be injected into LLM prompts via to_context_string().

​
Filtering Tables

Control which tables to discover:

​
Discovery Options

​
Browse Saved Catalogs

After discovery, catalogs are saved at ~/.anysite/catalogs/<connection>.yaml and can be browsed anytime:
Use anysite db catalog mydb --json to pipe database context into AI agents. The JSON format includes all tables, columns, relationships, and LLM descriptions — everything an agent needs to understand your data.

​
Commands Reference

​
Next Steps

Database Operations

Insert, query, and sync data with your databases

Agent Protocol

Structured JSON output for AI agent integration