SQLiteDb

​

Constructor

from agno.db.sqlite import SQLiteDb

db = SQLiteDb(db_file="agent.db")

​

Parameters

​

Methods

​

close()

db.close()

​

Example Usage

from agno import Agent
from agno.db.sqlite import SQLiteDb

db = SQLiteDb(db_file="my_agent.db")

agent = Agent(
    name="Assistant",
    model="gpt-4o",
    db=db,
    add_history_to_context=True
)

# Conversations are automatically saved
response = agent.run("Hello!", user_id="user_1")
response = agent.run("What did I just say?", user_id="user_1")

# Get session history
session = agent.get_session()
print(f"Session has {len(session.runs)} runs")

​

Configuration

​

Custom Database Location

db = SQLiteDb(db_file="/path/to/database.db")

​

Custom Table Names

db = SQLiteDb(
    db_file="agent.db",
    session_table="my_sessions",
    memory_table="my_memories"
)

​

In-Memory Database

# For testing
db = SQLiteDb(db_file=":memory:")

​

Best Practices

1. Close connections: Call db.close() when shutting down
2. Use for development: SQLite is great for development and small deployments
3. PostgreSQL for production: Use PostgreSQL for production workloads
4. Backup regularly: SQLite is just a file - back it up regularly
5. One writer at a time: SQLite doesn’t handle concurrent writes well

​

Limitations

• Limited concurrency (single writer)
• Not suitable for high-traffic production deployments
• No built-in replication
• Use PostgreSQL for production environments