> ## Documentation Index
> Fetch the complete documentation index at: https://agno-v2-codex-docs-audit-20260719-0149.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# SQLite for Team

> Store team sessions and run history in a local SQLite database with SqliteDb.

`SqliteDb` stores a Team's sessions and run history in SQLite.

## Usage

`SqliteDb` uses `db_engine`, then `db_url`, then `db_file`. If none is provided, it creates `agno.db` in the current directory. The following example uses `db_file`.

Install dependencies:

```shell theme={null}
uv pip install agno openai ddgs sqlalchemy
```

Set your OpenAI API key:

<CodeGroup>
  ```bash Mac/Linux theme={null}
  export OPENAI_API_KEY=your_api_key
  ```

  ```powershell Windows theme={null}
  $env:OPENAI_API_KEY = "your_api_key"
  ```
</CodeGroup>

```python sqlite_for_team.py theme={null}
from typing import List

from agno.agent import Agent
from agno.db.sqlite import SqliteDb
from agno.models.openai import OpenAIResponses
from agno.team import Team
from agno.tools.hackernews import HackerNewsTools
from agno.tools.websearch import WebSearchTools
from pydantic import BaseModel

db = SqliteDb(db_file="tmp/data.db")

class Article(BaseModel):
    title: str
    summary: str
    reference_links: List[str]

hn_researcher = Agent(
    name="HackerNews Researcher",
    model=OpenAIResponses(id="gpt-5.2"),
    role="Gets top stories from HackerNews.",
    tools=[HackerNewsTools()],
)

web_searcher = Agent(
    name="Web Searcher",
    model=OpenAIResponses(id="gpt-5.2"),
    role="Searches the web for information on a topic",
    tools=[WebSearchTools()],
    add_datetime_to_context=True,
)

hn_team = Team(
    name="HackerNews Team",
    model=OpenAIResponses(id="gpt-5.2"),
    members=[hn_researcher, web_searcher],
    db=db,
    instructions=[
        "First, search HackerNews for what the user is asking about.",
        "Then, ask the web searcher to search for each story to get more information.",
        "Finally, provide a thoughtful and engaging summary.",
    ],
    output_schema=Article,
    markdown=True,
    show_members_responses=True,
)

hn_team.print_response("Write an article about the top 2 stories on HackerNews")
```

Run the team:

```shell theme={null}
python sqlite_for_team.py
```

## Parameters

<Snippet file="db-sqlite-params.mdx" />