smartkdb 1.0.0

SmartKDB – AI-ready embedded database engine with smart indexing and configuration UI

SmartKDB

SmartKDB is a production-ready, AI-enhanced embedded database engine for Python. It combines the structured data model of SQL with the flexibility of NoSQL, adding a lightweight AI layer for semantic querying and automatic indexing.

Features

• Hybrid Data Model: Structured tables + JSON documents.
• AI-Powered:
  • Semantic Querying: db.semantic_query("users", "users older than 25")
  • Auto-Indexing: Automatically detects hot fields and creates indexes.
• Built-in Management:
  • HTML Dashboard: Manage your DB visually via kdb_config.html.
  • CLI: smartkdb init, smartkdb status, smartkdb shell.
• Secure: Role-Based Access Control (RBAC) with hashed passwords.
• Zero Dependencies: Pure Python, runs anywhere.

Installation

pip install smartkdb

Quick Start

1. CLI Usage

Initialize a new database:

smartkdb init mydb.kdb

Check status:

smartkdb status mydb.kdb

2. Python Usage

from kdb import SmartKDB

# Initialize
db = SmartKDB("mydb.kdb")

# Login (Default admin/admin created by CLI init)
db.login("admin", "admin")

# Create Table
users = db.create_table("users", indexes=["age"])

# Insert
users.insert({"name": "Alice", "age": 30, "role": "engineer"})

# Semantic Query
results = db.semantic_query("users", "engineers older than 20")
print(results)

Configuration Dashboard

SmartKDB includes a visual configuration tool.

1. Locate kdb_config.html in your package installation or download it from the repo.
2. Open it in your browser.
3. Point it to your database configuration files (export/import supported).

License

MIT License