# sqlite-expert

> SQLite database optimization, query writing, indexing, and best practices specialist. Proactively analyzes and optimizes SQLite databases for performance a

- Source: https://doutorai.pt/en/components/agents__0xfurai-subagents__agents-sqlite-expert
- Type: Agents
- Category: General
- Downloads: 0
- Site: Doutor AI (https://doutorai.pt/en) - AI tools for small businesses

An open-source community component, curated and adapted by Doutor AI.

## What it does and how to use it

A **specialized AI agent** for general. It gives Claude Code the knowledge, tone and criteria of an expert in this field, to handle complex tasks with professional quality - without you having to explain everything from scratch.

1. Install the agent with the command above, in your project folder.
2. Open Claude Code and describe the task in plain language.
3. Claude picks this agent automatically when the task fits (or you can call it directly).
4. Review the result and iterate - the agent keeps the context.

## Install (Claude Code)

```bash
mkdir -p .claude/agents && curl -fsSL https://doutorai.pt/data/lib/agents__0xfurai-subagents__agents-sqlite-expert.md -o .claude/agents/0xfurai-subagents__agents-sqlite-expert.md
```

Paste this command into the terminal, in your project folder, and the component installs automatically.

## Content

```
---
name: sqlite-expert
description: SQLite database optimization, query writing, indexing, and best practices specialist. Proactively analyzes and optimizes SQLite databases for performance and reliability.
model: claude-sonnet-4-20250514
---

## Focus Areas

- Understanding SQLite architecture and file structure
- Writing efficient SQL queries with proper indexing in SQLite
- Optimization techniques specific to SQLite
- Managing SQLite database transactions and concurrency
- Best practices for schema design tailored for SQLite
- Handling large datasets efficiently within SQLite constraints
-

- 🔒 Full content on the Pro plan (€7.99/month) -
```

## Related components

- [3d-artist](https://doutorai.pt/en/components/agents__3d-artist): 3D art and asset creation specialist for game development. Use PROACTIVELY for 3D modeling, texturing, animation, asset optimization, and te
- [4.1-Beast](https://doutorai.pt/en/components/agents__4-1-beast): GPT 4.1 as a top-notch coding agent.
- [BettorEdge Value Finder](https://doutorai.pt/en/components/agents__bettoredge-value-finder): Find +EV betting opportunities on BettorEdge prediction markets with edge calculation, Kelly criterion sizing, and bankroll management
- [CSharpExpert](https://doutorai.pt/en/components/agents__csharpexpert): An agent designed to assist with software development tasks for .NET projects.
- [README](https://doutorai.pt/en/components/agents__readme): Language Specialists are your expert guides for specific programming languages and their ecosystems. These subagents bring deep knowledge of
- [Thinking-Beast-Mode](https://doutorai.pt/en/components/agents__thinking-beast-mode): A transcendent coding agent with quantum cognitive architecture, adversarial intelligence, and unrestricted creative freedom.

## Save hours every week with AI, no hassle

**Doutor AI** gives you 1,859 ready-to-copy AI prompts, by industry and in plain English - plus a complete technical library for those who want to go further. [See plans →](https://doutorai.pt/en/pricing)

---
Content by Doutor AI (https://doutorai.pt/en). When quoting, please cite the source: https://doutorai.pt/en/components/agents__0xfurai-subagents__agents-sqlite-expert