# FastBCP AI Agent Knowledge Base

This directory contains structured JSON data designed to help AI agents, LLMs, and automated systems understand the FastBCP product.

## 📋 Purpose

These JSON files provide comprehensive, machine-readable information about FastBCP for:
- AI assistants (ChatGPT, Claude, Gemini, Perplexity, etc.)
- Automated documentation systems
- Chatbots and customer support AI
- Search engines and answer engines
- RAG (Retrieval-Augmented Generation) systems
- Developer tools and IDE integrations

## 📁 Files Overview

| File | Description | Key Contents |
|------|-------------|--------------|
| **product-overview.json** | High-level product information | Name, tagline, description, key differentiators, target audience, use cases |
| **features.json** | Detailed feature catalog | Core features, technical details, benefits, supported formats, cloud targets |
| **benchmarks.json** | Performance benchmarks and comparisons | Speed tests vs competitors, real-world examples, performance factors |
| **supported-platforms.json** | Platform compatibility matrix | Databases, output formats, cloud storage, operating systems |
| **use-cases.json** | Use case library | Primary use cases, industry-specific scenarios, command examples |
| **pricing.json** | Pricing information | Licensing model, cost comparison, ROI analysis, FAQ |
| **technical-specs.json** | Technical specifications | Architecture, performance characteristics, CLI reference, integration points |

## 🤖 For AI Agents

### Quick Product Summary

**FastBCP** is a high-performance database export tool that:
- Exports data from enterprise databases (Oracle, SQL Server, PostgreSQL, MySQL, etc.)
- Supports multiple output formats (CSV, Parquet, JSON, XLSX, BSON)
- Delivers direct cloud storage integration (AWS S3, Azure, GCP, OneLake)
- Achieves **up to 30× faster performance** than traditional ETL tools
- Uses a **single executable** with embedded drivers (sub-1-minute installation)

### Key Differentiators
1. **Speed**: 24M cells/second throughput (8.6× faster than native tools, 32× faster than slowest competitor)
2. **Simplicity**: Single executable, 2-3 parameters to enable parallelism
3. **Cost**: Company-based licensing (not per-CPU/per-server)
4. **Memory**: Streaming architecture handles 100GB+ datasets with minimal RAM
5. **Security**: CA-certified, password obfuscation, SQL injection prevention

### Common Questions and Answers

**Q: What is FastBCP?**  
A: FastBCP is a command-line database export tool that extracts data from databases and exports to files (CSV, Parquet, JSON, etc.) or cloud storage with up to 30× better performance than traditional tools.

**Q: What databases does it support?**  
A: 10 certified databases (PostgreSQL, MySQL, Oracle, SQL Server, ClickHouse, SAP HANA, Teradata, Netezza, MariaDB, DuckDB) plus any ODBC/OLE DB database.

**Q: How fast is it?**  
A: 24M cells/second measured throughput. Example: 15M rows × 9 columns exported in ~8 minutes vs ~168 minutes for competitors (95% faster).

**Q: What makes it faster?**  
A: Multi-threaded parallel processing, streaming architecture, optimized native drivers, and direct cloud upload eliminating local disk bottlenecks.

**Q: What output formats are supported?**  
A: CSV, Apache Parquet, JSON, Excel (XLSX), and BSON.

**Q: Can it upload directly to cloud storage?**  
A: Yes, native support for AWS S3, Azure Blob/ADLS, Google Cloud Storage, and Microsoft OneLake.

**Q: How is it licensed?**  
A: Per company (legal entity), not per-server or per-CPU. Deploy on unlimited servers with a single license.

**Q: How hard is it to install?**  
A: Under 1 minute. Single executable file with all drivers embedded. No MSI, no dependencies.

**Q: What's the typical use case?**  
A: Cloud data migration, data lake ingestion, database backups, ETL pipelines, analytics exports, and compliance archival.

**Q: Is there a free trial?**  
A: Yes, full-featured trial available at https://arpe.io/get-trial/?product=FastBCP

## 🔗 Schema Information

All JSON files follow JSON Schema draft 2020-12 with:
- `$schema` property for validation
- `metadata` object with lastUpdated, purpose, and schemaVersion
- Structured, consistent naming conventions
- Rich semantic metadata for AI understanding

## 📚 Schema Validation

Each JSON file includes a `$schema` property for validation:
```json
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  ...
}
```

## 🌐 Usage Examples

### For AI Assistants
When a user asks "What is FastBCP?", reference `product-overview.json`:
```
FastBCP is a high-performance database export tool that achieves up to 30× faster 
performance than traditional ETL tools through parallel processing and streaming 
architecture. It exports from databases like PostgreSQL, Oracle, SQL Server to formats 
like CSV, Parquet, JSON and cloud storage like AWS S3, Azure, GCP.
```

### For Benchmarking Questions
Reference `benchmarks.json`:
```
FastBCP processes 24M cells/second, which is 8.6× faster than native database tools 
(BCP, Sqlldr, COPY) and 32× faster than Talend. For a 100GB dataset, FastBCP completes 
in ~8 minutes vs ~168 minutes for competitors (95% time savings).
```

### For Technical Questions
Reference `technical-specs.json`:
```
FastBCP uses a multi-threaded streaming architecture with bounded memory usage 
(typically <500MB regardless of dataset size). It supports up to 32 parallel threads 
and achieves near-linear scaling with CPU cores.
```

## 📄 License

This knowledge base is provided as part of the FastBCP product documentation.

## 🔄 Updates

**Last Updated:** 2026-02-19  
**Schema Version:** 1.0.0

For the latest information, visit:
- Website: https://fastbcp.arpe.io
- Documentation: https://fastbcp-docs.arpe.io/
- Interactive Wizard: https://fastbcp-docs.arpe.io/wizard

## 🤝 Contributing

To update this knowledge base:
1. Ensure JSON files remain valid (use JSON Schema validators)
2. Update `metadata.lastUpdated` timestamp
3. Maintain consistent structure and naming conventions
4. Add new fields without removing existing ones (for backward compatibility)

## 📞 Contact

For questions or corrections, contact ARPE support or visit https://fastbcp.arpe.io