Weaviate Database Operations

This skill provides comprehensive access to Weaviate vector databases including search operations, natural language queries, schema inspection, data exploration, filtered fetching, collection creation, and data imports.

Weaviate Cloud Instance

If the user does not have an instance yet, direct them to the cloud console to register and create a free sandbox. Create a Weaviate instance via Weaviate Cloud.

Environment Variables

Required:

• WEAVIATE_URL - Your Weaviate Cloud cluster URL
• WEAVIATE_API_KEY - Your Weaviate API key

External Provider Keys (auto-detected):
Set only the keys your collections use, refer to Environment Requirements for more information.

Script Index

Search & Query

• Query Agent - Ask Mode: Use when the user wants a direct answer to a question based on collection data. The Query Agent synthesizes information from one or more collections and returns a structured response with source citations (collection name and object ID).
• Query Agent - Search Mode: Use when the user wants to explore or browse raw objects across one or more collections. Unlike ask mode, this returns the actual data objects rather than a synthesized answer.
• Hybrid Search: Default choice for most searches. Provides a good balance of semantic understanding and exact keyword matching. Use this when you are unsure which search type to pick.
• Semantic Search: Use for finding conceptually similar content regardless of exact wording. Best when the intent matters more than specific keywords.
• Keyword Search: Use for finding exact terms, IDs, SKUs, or specific text patterns. Best when precise keyword matching is needed rather than semantic similarity.

Collection Management

• List Collections: Use to discover what collections exist in the Weaviate instance. This should typically be the first step before performing any search or data operation.
• Get Collection Details: Use to understand a collection's schema — its properties, data types, vectorizer configuration, replication factor, and multi-tenancy status. Helpful before running searches or imports.
• Explore Collection: Use to analyze data distribution, top values, and inspect actual content in a collection. Helpful for understanding what data looks like before querying.
• Create Collection: Use to create new collections with custom schemas before importing data. Do not specify a vectorizer unless the user explicitly requests one (the default text2vec_weaviate is used).

Data Operations

• Fetch and Filter: Use to retrieve specific objects by ID or strictly filtered subsets of data. Best for precise data retrieval rather than search.
• Import Data: Use this when the user asks to import, load, or ingest a file (CSV, JSON, JSONL, PDF) into a collection.
• Create Example Data: Use to create example data for immediate use of other skills, if no data is available or user requests some toy data.

Free-Tier Clusters

Weaviate Cloud free-tier clusters have limits that can change; if a script's error contradicts this section, trust the error.

• One collection only. A second create is refused with 429 USAGE_LIMIT_EXCEEDED ("collections count limit of 1 reached"). Run list_collections.py first. If a collection exists, import into it instead of creating another, and ask the user before using the only slot.
• example_data.py uses that slot; a PDF import is refused. example_data.py creates one collection whose name depends on --domain (AI_Arxiv for the default academic; Income_Tax_Returns, Product_Catalog, Hair_Medical or IT_Support_Tickets for the others). Do not run it unless the user agrees to spend the slot. import.py on a PDF creates its collection automatically, and free-tier clusters refuse that create with 422 CONFIG_NOT_ALLOWED; if the user asks for a PDF import, tell them it is refused on a free-tier cluster and let them decide. No script here deletes a collection.
• Only the hfresh vector index is accepted. A create that asks for another type (for example hnsw) is refused with 422 CONFIG_NOT_ALLOWED. The scripts pin weaviate-client 4.23.1, which leaves the index type to the server; older clients request hnsw and are refused. If a 422 says hnsw is not allowed on 4.23.1 or newer, tell the user rather than retrying.

Recommendations

1. Start by listing collections if you don't know what's available:

   uv run scripts/list_collections.py

1. Ask the user if they want to create example data if nothing is available and the user requests it. Otherwise continue.

   uv run scripts/example_data.py

1. Get collection details to understand the schema:

   uv run scripts/get_collection.py --name "COLLECTION_NAME"

1. Explore collection data to see values and statistics:

   uv run scripts/explore_collection.py "COLLECTION_NAME"

1. Create a collection if importing a new CSV, JSON, or JSONL file — the collection must exist before importing:

   uv run scripts/create_collection.py CollectionName \
     --properties '[{"name": "title", "data_type": "text"}, {"name": "body", "data_type": "text"}]'

Do not specify a vectorizer unless the user explicitly requests one.

1. Import data into an existing collection:

   uv run scripts/import.py "data.csv" --collection "CollectionName"

For PDF imports, the collection is created automatically — skip step 5.

1. Choose the right search type:

• Get AI-powered answers with source citations across multiple collections → ask.py
• Get raw objects from multiple collections → query_search.py
• General search → hybrid_search.py (default)
• Conceptual similarity → semantic_search.py
• Exact terms/IDs → keyword_search.py

Output Formats

All scripts support:

• Markdown tables (default and recommended)
• JSON (--json flag)

Error Handling

Common errors:

• WEAVIATE_URL not set → Set the environment variable
• Collection not found → Use list_collections.py to see available collections
• Authentication error → Check API keys for both Weaviate and vectorizer providers