# Outerbase Studio

`@outerbase/studio` enables you to easily connect and serve your database interface externally with just a simple command-line command.

```
npx @outerbase/studio sqlite.db
```

Put it behind the basic authentication

```
npx @outerbase/studio sqlite.db --user=admin --pass=123
```

## Configuration File

Connect from configuration file. `outerbase.json`

```
{
  "driver": "sqlite",
  "connection": {
    "file": "sqlite.db"
  }
}
```

`@outerbase/studio` will try to open `outerbase.json` by default if no configuration file specified

```
npx @outerbase/studio
```

You can specify the configuration file as the following

```
npx @outerbase/studio --config=other-config-file.json
```

By default, `@outerbase/studio` use port `4000`. You can specify different port

```
{
  "driver": "sqlite",
  "connection": {
    "file": "sqlite.db"
  },
  "port": 4002
}
```

You can add authentication

```
{
  "driver": "sqlite",
  "connection": {
    "file": "sqlite.db"
  },
  "port": 4002,
  "auth": {
    "user": "admin",
    "pass": "123"
  }
}
```

## Drivers

### sqlite

We also support sqlite ATTACH

```
{
  "driver": "sqlite",
  "connection": {
    "file": "sqlite.db"
    "attach": {
        "demo": "demo.db'
    }
  }
}
```

### turso

```
{
  "driver": "turso",
  "connection": {
    "url": "libsql://example.turso.io",
    "token": "xxx",
    "attach": {
      "demo": "turso-database-id-here"
    }
  }
}
```

### mysql

```
{
  "driver": "mysql",
  "connection": {
    "database": "chinook",
    "host": "localhost",
    "port": 3306,
    "user": "root",
    "password": "123456"
  }
}
```

### postgreSQL

```
{
  "driver": "postgres",
  "connection": {
    "database": "my_database",
    "host": "localhost",
    "port": 3306,
    "user": "root",
    "password": "123456",
    "ssl": true
  }
}
```