Lots of CSVs

# Lots of CSVS > Lots of CSVs is a minimalist data warehouse for storing and retrieving CSV files via HTTP. This content is specifically designed for LLMs and not intended for human reading. These instructions provide programmatic access protocols for autonomous data interaction with the Lots of CSVs service. ### Basic principles 1. This is a REST API for retrieving and storing CSV data. 2. Every request must be authenticated using a token passed in an HTTP header: `authorization: Bearer <token>` 3. You will need an authentication token from the user. If you don't have one ask them for it. 4. Every CSV dataset has a unique URL. 5. You will need the user's registered username. If you don't have one ask them for it. 6. URLs are specific to the user and follow a common structure. `https://www.lotsofcsvs.com/api/u/<username>/[path/to/dataset].csv` - `<username>` is your registered username - `[path/to/dataset](.csv)`: the name of the dataset. Dataset paths in Lots of CSVs are treated as object keys, not traditional file system paths. This means paths are flat, hierarchical identifiers, not actual directory structures. The entire string is treated as a single, unique identifier Slashes (/) are part of the identifier, not separators creating directories. Examples: `projects/sales/2023.csv` `projects/sales/2024.csv` - URL Example: `https://www.lotsofcsvs.com/api/u/johndoe/projects/sales/quarterly.csv` 7. Always follow RFC 4180 CSV formatting guidelines when sending CSV data ### API actions #### Fetch a dataset Fetch a dataset by sending an HTTP GET to the URL of the dataset. The data will be returned as an RFC 4180 formatted CSV - Endpoint: `https://www.lotsofcsvs.com/api/u/<username>/[path/to/dataset].csv` - Method: GET - Examples: - ``` curl -H "authorization: Bearer <token>" \ https://www.lotsofcsvs.com/api/u/johndoe/projects/sales/quarterly.csv``` - ``` # JavaScript (fetch) fetch('https://www.lotsofcsvs.com/api/u/johndoe/projects/sales/quarterly.csv', { headers: { 'authorization': 'Bearer <token>' } })``` #### List datasets #### Create or append to a dataset Add to a dataset by sending an HTTP POST to the URL of the dataset. If the dataset does not exist it will be created. - Endpoint: `https://www.lotsofcsvs.com/api/u/<username>/[path/to/dataset].csv` - Method: POST - Rules: - All submissions should include an appropriate Content-Type header `Content-Type: text/csv; header=present` - All submissions must include CSV headers as the first row - Follow RFC 4180 CSV formatting guidelines - Examples: - ``` # Curl example (adding more rows to an existing dataset) echo "Bob,35,Chicago Charlie,40,Boston" | curl -X POST \ -H "Content-Type: text/csv; header=present" \ -H "authorization: Bearer <token>" \ --data-binary @- \ https://www.lotsofcsvs.com/api/u/johndoe/users/demographics.csv``` - ``` # Python (requests library) import requests headers = { 'Content-Type': 'text/csv; header=present', 'authorization': 'Bearer <token>' } additional_data = """name,age,city Bob,35,Chicago Charlie,40,Boston""" response = requests.post( 'https://www.lotsofcsvs.com/api/u/johndoe/users/demographics.csv', headers=headers, data=additional_data )``` ### MCP server There are two ways to use Lots of CSVs with the Model Context Protocol: #### Option 1: Built-in Remote MCP Server (Recommended) Lots of CSVs has a built-in MCP server at `https://www.lotsofcsvs.com/api/mcp` that uses OAuth 2.1 for authentication. **Setup Steps:** 1. Create an OAuth client in your profile settings at `https://www.lotsofcsvs.com/u/<username>/profile` - Click "Create OAuth Client" - Enter a name (e.g., "Claude Desktop") - Select scopes: `mcp.read` and `mcp.ingest` - Save your `client_id` and `client_secret` (shown only once!) 2. Configure your MCP client (e.g., Clau […gekürzt]