v1.0.0 - Initial Release

Flexible Database Design v1.0.0

First public release. Reusable "soft schema" design methodology + ready-to-use SQLite implementation. Lets AI agents guide you to build flexible databases for personal knowledge bases, fragment collection, forms, and multi-source aggregation.

✨ Features

• Soft schema design: Fixed core columns + flexible JSON/key-value fields; three-layer model (raw → soft fields → views)
• FlexibleDatabase core: Archive, query, soft delete, restore, update, batch import
• CLI tools: archive_item, query_items, manage_item, import_batch, quick_validate
• Extractor abstraction: Support FLEXIBLE_EXTRACTOR or --llm-extract for LLM integration
• Full-text search: Optional FTS5, recall() with FTS + LIKE fallback
• Zero external dependencies: Python 3.6+, SQLite only

📚 Documentation

• SKILL.md: Methodology + Agent workflow + scenario quick reference
• docs/API.md: FlexibleDatabase API reference
• Example scenarios: Financial reports, forex, surveys, multi-source aggregation

🤖 Compatibility

Claude Skills, Cursor, OpenClaw, Cherry Studio, and other AI workbenches.