The server architecture revolves around exposing Cursor's SQLite databases to AI assistants using the Model Context Protocol. It manages resources efficiently using MCP's lifespan API. The CursorDBManager component is responsible for discovering and managing Cursor projects and their databases. Resources are designed to expose data from the Cursor databases.