Blink API Development Skill

What problem does it solve?

This Skill empowers developers to efficiently extend and maintain the Blink project's FastAPI backend, which directly interfaces with Cursor IDE's SQLite database. It simplifies tasks like adding new API endpoints, modifying database queries, and understanding the complex Cursor database schema, saving time on backend development and integration.

Core Features & Use Cases

• FastAPI Endpoint Creation: Follow a clear pattern for adding new REST API endpoints with automatic documentation.
• Database Interaction: Learn common SQLite query patterns for cursorDiskKV and ItemTable to retrieve chat and message data.
• Data Structure & Helpers: Understand the JSON structure of Composer (Chat) and Bubble (Message) data, and utilize helper functions for timestamp parsing and content extraction.
• Use Case: To add an endpoint that retrieves only archived chats, use this skill to guide you through creating a new FastAPI route, writing the correct SQL query for cursorDiskKV to filter composerData by isArchived, and ensuring the response follows standard pagination.

Quick Start

I need to add a new API endpoint to rest/cursor_chat_api.py that returns a list of all chat IDs. Provide the basic FastAPI endpoint structure and the SQLite query needed to fetch composerData keys.