# Shell Test Scripts

This directory contains comprehensive test scripts for the Skraak MCP Server.

## Quick Start

All scripts default to using the test database for safety. Simply run without arguments:

```bash
cd shell_scripts

# Quick time check
./get_time.sh

# Test SQL queries (pipe to file!)
./test_sql.sh > test_output.txt 2>&1

# Test write tools
./test_tools.sh > tools_output.txt 2>&1

# Test imports
./test_import_file.sh > import_output.txt 2>&1
./test_import_selections.sh > selections_output.txt 2>&1
./test_bulk_import.sh > bulk_output.txt 2>&1

# Test resources/prompts
./test_resources_prompts.sh | jq '.'
./test_all_prompts.sh > prompts_output.txt 2>&1
```

## Available Scripts

| Script | Description | Database |
|--------|-------------|----------|
| `get_time.sh` | Test get_current_time tool | None required |
| `test_sql.sh` | Test execute_sql with various queries | test.duckdb (default) |
| `test_tools.sh` | Test all 8 write tools (create/update) | test.duckdb (default) |
| `test_import_file.sh` | Test single file import | test.duckdb (default) |
| `test_import_selections.sh` | Test ML selection import | test.duckdb (default) |
| `test_bulk_import.sh` | Test CSV-based bulk import | test.duckdb (default) |
| `test_resources_prompts.sh` | Test schema resources and prompts | test.duckdb (default) |
| `test_all_prompts.sh` | Test all 6 SQL workflow prompts | test.duckdb (default) |

## Safety

✅ **All scripts default to test database** (`test.duckdb`) for safety.

⚠️ **Never use production database** (`skraak.duckdb`) for testing!

**Note:** Scripts use different path formats:
- Simple scripts: `../db/test.duckdb` (relative)
- Complex scripts: Absolute paths resolved at runtime

## Documentation

See `TESTING.md` for comprehensive testing documentation including:
- Manual JSON-RPC testing
- Expected responses
- SQL query examples
- Troubleshooting
- Best practices