info-record

You can prevent duplicate business intelligence collection by recording items in a persistent SQLite database. The system checks if a source URL already exists before collection and filters records by creation date for daily reporting.

To check if a source URL has already been captured in SQLite, the system queries the `intel_items` table in `info_record.db`. It returns a JSON output indicating whether the given source exists before you open and collect the details again.

The best way to compile a daily intel report is by querying the SQLite database for items collected today. The system filters records using the `created_at` timestamp and returns a JSON output of the day's gathered business research for your deliverables.

Yes, you need sqlite3 to record and deduplicate gathered intel items. The Skill depends on sqlite3 to maintain the `info_record.db` database file and insert rows into the `intel_items` table for persistent tracking.

JSON output works by returning structured data from check, record, and query scripts against the SQLite database. When querying today's collected intel items, the system filters by the `created_at` date and outputs the results in JSON format for downstream integration.