WIP: Caution!!! AI code and probably wrong in many ways though it "runs".

Workspace DB Manager

A TypeScript MCP (Model Context Protocol) server for managing workspace databases with filesystem integration.

Features

- SQLite database management with automatic discovery
- Real-time filesystem monitoring for database changes
- Database connection pooling and management
- Automatic database tracking and status updates
- Cross-database operations support
- TypeScript/ES Module architecture

Getting Started

1. Install dependencies:

npm install

2. Build the TypeScript code:

npm run build

3. Initialize the core database:

npm run init-db

4. Start the server:

npm start

Development

# Run in development mode with auto-reload
npm run dev
Run tests
npm test
Build TypeScript
npm run build

Continuous Integration

This project uses GitHub Actions for continuous integration:

- Runs on Node.js 20.x, 21.x, and 22.x
- Automatically runs tests on every push and pull request
- Checks TypeScript compilation
- Generates and uploads test coverage reports
- Fails if code quality standards are not met

Configuration

The server can be configured through a WorkspaceConfig object:

const manager = new WorkspaceDBManager({
    watchPaths: ['/path/to/workspace'],
    pollInterval: 1000, // Optional: file system polling interval
    database: {
        verbose: true // Optional: enable verbose database logging
    }
});

Database Operations

Automatic Database Discovery

The server automatically detects and tracks: - New database files - Database modifications - Database removals

Database Management

// List all managed databases
const databases = await manager.listManagedDatabases();
// Get system configuration

const config = await manager.getConfig('some_key');

Events

The server emits events for various operations: - database-added: When a new database is discovered - database-changed: When a database is modified - database-removed: When a database is removed - error: When an error occurs - initialized: When the server is fully initialized

Testing

# Run all tests
npm test
Run tests with coverage
npm test -- --coverage

Contributing

1. Fork the repository
2. Create your feature branch
3. Commit your changes
4. Push to the branch
5. Create a Pull Request

License

ISC