# augmentable-cli

> CLI for working with CSV files by importing into SQLite

Latest version **0.1.0** (published 2018-02-19) · MIT license · 0 weekly downloads

## Install

```sh
npm install augmentable-cli
pnpm add augmentable-cli
yarn add augmentable-cli
bun add augmentable-cli
```

Provides the commands `aug`, `aug-sql`, `augmentable`, `augmentable-sql`.

## Health

**Score 15/100 (F)** — status: abandoned.

Positive: no vulnerabilities.

Warnings: low downloads; no types; no esm support; pre 1.0.

Negative: abandoned; low maintenance score.

## Facts

| | |
|---|---|
| Version | 0.1.0 |
| Published | 2018-02-19 |
| First published | 2018-02-19 |
| Weekly downloads | 0 |
| License | MIT |
| TypeScript types | none |
| Module format | CommonJS |
| Dependencies | 10 |
| Unpacked size | 91.6 KB |
| Known vulnerabilities | 0 |
| Install scripts | no |
| Author | Patrick DeVivo |
| Maintainers | patrickdevivo |

## Links

- npm: https://www.npmjs.com/package/augmentable-cli
- npm.io page: https://npm.io/package/augmentable-cli

## Dependencies (10)

- [ora](https://npm.io/package/ora.md) ^1.4.0
- [chalk](https://npm.io/package/chalk.md) ^2.3.1
- [moment](https://npm.io/package/moment.md) ^2.20.1
- [numbro](https://npm.io/package/numbro.md) ^2.0.5
- [caporal](https://npm.io/package/caporal.md) ^0.9.0
- [inquirer](https://npm.io/package/inquirer.md) ^5.1.0
- [fast-glob](https://npm.io/package/fast-glob.md) ^2.0.4
- [cli-table2](https://npm.io/package/cli-table2.md) ^0.2.0
- [csv-sqlite](https://npm.io/package/csv-sqlite.md) ^0.1.1
- [console-png](https://npm.io/package/console-png.md) ^1.2.1

## Recent versions

- 0.1.0 (latest) — 2018-02-19

## README

<p align="center">
    <img src ="/assets/icon.png" />
</p>
<!-- [![Augmentable](/assets/icon.png)](https://www.augmentable.io/) -->

# augmentable-cli

* [Overview](#overview)
* [Importing Data](#importing-data)


## Overview

Augmentable CLI is a small command line utility for working with CSV and similarly structured text-based data files. It relies heavily on SQLite, and provides two primary utilities: importing data files into SQLite tables, and subsequent querying of those tables. It tries not to reinvent the wheel, and is designed to be comfortable to use and easy to integrate with scripts and other applications.


## Importing Data

CSVs are everywhere, but unfortunately are not always pleasant to query. Spreadsheets are easy to use, but can be clumsy and sometimes limiting. Custom scripts and python notebooks are versatile, but may be overkill for certain applications.

Augmentable is a set of tools designed to ease some of the pain involved in asking basic questions of text-based data. You can create a *project*, which is simply a SQLite database file in a special directory on your machine: `~/.augmentable`. You can then run an import process, specifying a CSV (or CSV-like) file and some parameters (delimiter, header row, etc) which will copy that file into a new or existing SQLite table.

- `augmentable projects:create myNewProject`
- `augmentable file:import /path/to/my/file.csv myNewProject myNewTable --header 0 -- delimiter ;`
- `augmentable sql:exec mynewProject 'SELECT * FROM myNewTable'`

---
_Source: https://npm.io/package/augmentable-cli · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._