mixtape-tools 0.4.0

Ready-to-use tool implementations for the mixtape agent framework
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124

# SQLite Tools

A comprehensive set of SQLite database tools for AI agents, with granular permission control.

## Quick Start

```rust
use mixtape_core::Agent;
use mixtape_tools::sqlite;

// Read-only agent
let agent = Agent::builder()
    .bedrock(ClaudeSonnet4)
    .add_tools(sqlite::read_only_tools())
    .build()
    .await?;

// Full access agent
let agent = Agent::builder()
    .bedrock(ClaudeSonnet4)
    .add_tools(sqlite::all_tools())
    .build()
    .await?;
```

## Tool Groups

| Function | Count | Description |
|----------|-------|-------------|
| `read_only_tools()` | 9 | Read-only operations - exploration, queries, backups |
| `destructive_tools()` | 7 | Write operations - schema changes, data modifications |
| `transaction_tools()` | 3 | Transaction management |
| `all_tools()` | 19 | Everything |

## Common Patterns

### Read-Only Explorer

For agents that should only query databases:

```rust
.add_tools(sqlite::read_only_tools())
```

Includes: open/close databases, list/describe tables, SELECT queries, export schema, backups.

### Data Entry

For agents that insert/update data but don't modify schema:

```rust
use mixtape_tools::sqlite::{self, *};

.add_tools(sqlite::read_only_tools())
.add_tool(WriteQueryTool)
.add_tool(BulkInsertTool)
.add_tools(sqlite::transaction_tools())
```

### Schema Migration

For agents that manage database schemas:

```rust
use mixtape_tools::sqlite::{self, *};

.add_tools(sqlite::read_only_tools())
.add_tool(CreateTableTool)
.add_tool(SchemaQueryTool)
.add_tool(ImportSchemaTool)
.add_tools(sqlite::transaction_tools())
```

## All Tools

### Safe (Read-Only)

| Tool | Description |
|------|-------------|
| `sqlite_open_database` | Open or create a database |
| `sqlite_close_database` | Close a database connection |
| `sqlite_list_databases` | Discover database files |
| `sqlite_database_info` | Get database metadata |
| `sqlite_list_tables` | List tables and views |
| `sqlite_describe_table` | Get table schema |
| `sqlite_read_query` | SELECT/PRAGMA/EXPLAIN queries |
| `sqlite_export_schema` | Export schema as SQL or JSON |
| `sqlite_backup` | Create database backup |

### Destructive (Write/Modify)

| Tool | Description |
|------|-------------|
| `sqlite_create_table` | Create a new table |
| `sqlite_drop_table` | Drop a table |
| `sqlite_write_query` | INSERT/UPDATE/DELETE |
| `sqlite_schema_query` | CREATE/ALTER/DROP DDL |
| `sqlite_bulk_insert` | Batch insert records |
| `sqlite_import_schema` | Import and execute schema |
| `sqlite_vacuum` | Optimize database storage |

### Transaction Management

| Tool | Description |
|------|-------------|
| `sqlite_begin_transaction` | Start a transaction |
| `sqlite_commit_transaction` | Commit a transaction |
| `sqlite_rollback_transaction` | Rollback a transaction |

## Multi-Database Support

All tools support working with multiple databases simultaneously. Use the `db_path` parameter to specify which database to operate on, or omit it to use the default (first opened) database.

```rust
// Open multiple databases
sqlite_open_database { db_path: "/data/users.db" }
sqlite_open_database { db_path: "/data/products.db" }

// Query specific database
sqlite_read_query {
    query: "SELECT * FROM users",
    db_path: "/data/users.db"
}
```