The Nest
Explore
0
README.md

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:

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