Discord AI Bot Development (Slimy.ai)

Development assistant for working with Slimy.ai, a feature-rich Discord bot built with Discord.js v14 that provides AI-powered chat, memory management, personality modes, and game-specific features (Super Snail stats analysis via GPT-4 Vision).

Project Architecture

Core Structure

**Entry Point**: `index.js`

**Command System**

**Handler System**

Data Layer

**Dual Storage System**

1. **JSON File Storage** (`lib/memory.js`)

- Uses `data_store.json` with file locking via `proper-lockfile`

- Stores: consent preferences, memos, channel mode configurations

- Atomic writes with temp file + rename pattern

- UUID-based IDs with race condition prevention

2. **MySQL Database** (`lib/database.js`)

- Connection pooling via `mysql2/promise`

- Optional (bot works without DB configured)

- Stores: users, guilds, memories, snail stats, image generation logs, personality metrics

- Auto-creates tables on initialization

- Check `database.isConfigured()` before using DB features

AI Integration

**OpenAI Client** (`lib/openai.js`)

**Personality Engine** (`lib/personality-engine.js`)

**Persona System** (`lib/persona.js`)

**Mode System** (`lib/modes.js`)

**Vision & Image Features**

**Google Sheets Integration**

Development Workflow

Running the Bot

```bash

Start the bot

npm start

or

node index.js

```

Command Deployment

```bash

Deploy slash commands to Discord

npm run deploy

or

node deploy-commands.js

```

**Deployment Strategy:**

Testing

```bash

Run memory persistence tests

npm run test:memory

or

node tests/memory-simple.test.js

```

**Test Coverage:**

Adding a New Command

1. Create `commands/yourcommand.js` with this structure:

```javascript

const { SlashCommandBuilder } = require('discord.js');

module.exports = {

data: new SlashCommandBuilder()

.setName('yourcommand')

.setDescription('Description'),

async execute(interaction) {

// Command logic

},

};

```

2. Deploy commands:

```bash

npm run deploy

```

3. Restart the bot:

```bash

npm start

```

Modifying Personality

1. Edit `bot-personality.md` (markdown format)

2. Reload without restart:

```

/personality-config reload

```

3. Test in channel with personality mode enabled

Database Schema Changes

1. Modify `createTables()` in `lib/database.js`

2. Drop/recreate tables or run manual migration

3. Update query methods as needed

4. Test with `database.testConnection()`

Key Commands Reference

**Memory Commands:**

**Chat Commands:**

**Mode Configuration:**

**Super Snail Features:**

**Utility Commands:**

Critical Patterns

Error Handling

Consent Management

File Locking

Conversation History

Environment Variables

**Required:**

**Optional:**

Recent Bug Fixes (as of 2025-10-09)

1. Memory persistence race conditions fixed with file locking

2. UUID-based memo IDs (replaced timestamp-based approach)

3. Proper async/await usage in save operations

4. Duplicate command loading prevention

5. Channel mode filter bug (DM notes appearing in guild queries)

Instructions for Claude Code

When working with this codebase:

1. **Before modifying commands:** Always check if the command already exists in `commands/` directory

2. **Database operations:** Always check `database.isConfigured()` before attempting DB operations

3. **Memory operations:** Verify consent before storing user data

4. **File operations:** Use proper-lockfile for concurrent access to JSON files

5. **Error handling:** Wrap all async operations in try/catch blocks

6. **Testing:** Run memory tests after modifying storage logic

7. **Deployment:** Use guild-specific deployment for testing, global for production

8. **Personality changes:** Use `/personality-config reload` instead of restarting bot

9. **Code style:** Follow existing patterns in commands and handlers

10. **Security:** Never commit API keys or service account credentials

When adding new features: