SQLite

pip install "praisonai[tools]"

from praisonai_tools import SQLiteTool

# Initialize
sqlite = SQLiteTool(path="mydata.db")

# Query
results = sqlite.query("SELECT * FROM users LIMIT 5")
print(results)

from praisonaiagents import Agent
from praisonai_tools import SQLiteTool

sqlite = SQLiteTool(path="mydata.db")

agent = Agent(
    name="DBAnalyst",
    instructions="You are a database analyst. Use SQLite to query data.",
    tools=[sqlite]
)

response = agent.chat("Show me all tables in the database")
print(response)

from praisonai_tools import SQLiteTool

sqlite = SQLiteTool(path="mydata.db")
results = sqlite.query("SELECT * FROM users WHERE active = 1")

sqlite.execute("CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT)")
sqlite.execute("INSERT INTO users (name) VALUES ('Alice')")

tables = sqlite.list_tables()

sqlite = SQLiteTool(
    path="mydata.db",      # Database file path
    timeout=30             # Connection timeout
)

from praisonai_tools import query_sqlite

# Quick query
results = query_sqlite("SELECT * FROM users", path="mydata.db")

# Use :memory: for temporary in-memory database
sqlite = SQLiteTool(path=":memory:")
sqlite.execute("CREATE TABLE test (id INTEGER, value TEXT)")

from praisonai_tools import SQLiteTool

sqlite = SQLiteTool(path="mydata.db")
result = sqlite.query("SELECT * FROM users")

if isinstance(result, dict) and "error" in result:
    print(f"Error: {result['error']}")
else:
    for row in result:
        print(row)