Database Tools

Database tools provide specialized interfaces for interacting with various database systems and vector stores within BroxiAI workflows.

Astra DB Tool

The Astra DB Tool provides direct access to DataStax Astra DB for database operations and queries.

Usage

This tool enables:

• Direct database queries

• Data manipulation operations

• Schema management

• Performance optimization

• Real-time data access

Inputs

Name	Display Name	Info
query	Query	Database query or operation to execute
api_key	API Key	Astra DB authentication key
endpoint	Endpoint	Astra DB API endpoint

Outputs

Name	Display Name	Info
result	Result	Query results or operation response

Astra DB CQL Tool

The Astra DB CQL Tool provides Cassandra Query Language (CQL) interface for Astra DB operations.

Usage

Advanced database operations using CQL:

• Complex queries with CQL syntax

• Batch operations

• Data modeling operations

• Performance-optimized queries

• Native Cassandra functionality

Inputs

Name	Display Name	Info
cql_query	CQL Query	Cassandra Query Language statement
keyspace	Keyspace	Target keyspace for the operation
api_key	API Key	Astra DB authentication credentials

Outputs

Name	Display Name	Info
result	Result	CQL query execution results

Retriever Tool

The Retriever Tool provides semantic search and retrieval capabilities across various data sources.

Usage

Intelligent information retrieval featuring:

• Semantic search across documents

• Vector-based similarity matching

• Multi-source data retrieval

• Context-aware results

• Relevance scoring

Inputs

Name	Display Name	Info
query	Search Query	Natural language search query
source	Data Source	Target data source or vector store
top_k	Top Results	Number of top results to retrieve
similarity_threshold	Threshold	Minimum similarity score for results

Outputs

Name	Display Name	Info
retrieved_docs	Retrieved Docs	Semantically relevant documents or data
scores	Relevance Scores	Similarity scores for each result

Usage Notes

• Database Agnostic: Support for multiple database systems and interfaces

• Query Optimization: Tools designed for efficient database operations

• Semantic Retrieval: AI-powered search and retrieval capabilities

• Enterprise Ready: Production-grade database connectivity

• Flexible Queries: Support for both SQL and NoSQL query languages

• Performance Focused: Optimized for high-performance data operations