Apify Keys

python3 ~/.openclaw/workspace/skills/apify-keys/scripts/get_key.py --list

How It Works

1. Connects to ColdCore MySQL database
2. Queries scrape_sm_accounts for active Apify accounts
3. Returns the account with the oldest last_used timestamp (least recently used)
4. Updates last_used to current timestamp after selection
5. Skips accounts with zero balance

Environment Variables

The script reads database credentials from these environment variables (falls back to defaults):

• COLDCORE_HOST — MySQL host
• COLDCORE_USER — MySQL username
• COLDCORE_PASS — MySQL password
• COLDCORE_DB — Database name (default: lead_generator)

Output

Default mode: prints just the API key string (for easy piping)

apify_api_xxxxx

JSON mode (--json):

{"id": 68, "api_key": "apify_api_xxxxx", "email": "[email protected]", "balance": 4.95}

Integration with Other Skills

Other skills that need Apify access should call this script to get a key:

APIFY_KEY=$(python3 ~/.openclaw/workspace/skills/apify-keys/scripts/get_key.py)
# Then use $APIFY_KEY in your API calls

Or in Python:

import subprocess
result = subprocess.run(
    ["python3", os.path.expanduser("~/.openclaw/workspace/skills/apify-keys/scripts/get_key.py"), "--json"],
    capture_output=True, text=True
)
key_data = json.loads(result.stdout)
api_key = key_data["api_key"]