kameleondb

What This Skill Does

KameleonDB is a highly flexible, agent-centric database management system designed to handle structured data without the constraints of traditional relational schema design. It acts as an "evolving" memory layer for your AI agent, allowing it to store, query, and mutate data structures on the fly. Unlike static databases that require complex migrations for every field addition, KameleonDB allows agents to "learn" data structures as they gather information. It supports complex querying, entity tracking, and persistent state management, making it an ideal choice for building long-term memory systems, CRM tools, or knowledge bases that grow alongside the agent's tasks.

Installation

To integrate KameleonDB into your OpenClaw environment, execute the following command in your terminal:

clawhub install openclaw/skills/skills/marcosnataqs/kameleondb

For standard deployment, ensure you have set your KAMELEONDB_URL environment variable. For local testing, a SQLite connection string (sqlite:///./kameleondb.db) is recommended, while production environments should utilize PostgreSQL with the kameleondb[postgresql] driver installed.

Use Cases

• CRM & Contact Management: Track people, emails, and professional relationships by adding fields like "linkedin_url" or "company" as you discover them.
• Dynamic Knowledge Bases: Aggregate research notes, facts, and document summaries into a searchable, queryable database that evolves as you add new information sources.
• Workflow Persistence: Store the status of long-running agent tasks, user preferences, and session-specific configurations to maintain continuity across multiple interaction cycles.
• Entity Tracking: Map complex relationships between diverse data points like tasks, projects, and deadlines without pre-defining rigid joins.

Example Prompts

1. "Initialize a new schema for 'ProjectTasks' with fields for title, priority, and due_date, then insert a task for 'Finalize Q4 report' due next Friday."
2. "Search my database for all contacts marked as 'Lead' and update their status to 'Follow-up Required' if their last interaction was over 30 days ago."
3. "Add a new column 'tags' to the 'KnowledgeBase' schema and categorize the last 10 entries based on their document content."

Tips & Limitations

• Proactive Schema Evolution: Don't be afraid to alter schemas as your data requirements grow. KameleonDB handles the restructuring automatically.
• Performance Monitoring: If you notice sluggish queries, use the self-optimizing hints provided by the tool to adjust indexing.
• Storage Limits: While SQLite is convenient for local agents, transition to a dedicated PostgreSQL instance once you exceed 10,000 records to maintain high-performance retrieval and write speeds.