diff --git a/.env.example b/.env.example
new file mode 100644
index 0000000..2da48f9
--- /dev/null
+++ b/.env.example
@@ -0,0 +1 @@
+SAAS_SITES_DB=/tmp/sites.db
diff --git a/.phan/config.php b/.phan/config.php
index 3e08c8e..51dda91 100644
--- a/.phan/config.php
+++ b/.phan/config.php
@@ -1,282 +1,283 @@
 <?php
 
 use Phan\Issue;
 
 /**
  * This configuration file was automatically generated by 'phan --init --init-level=3'
  *
  * This configuration will be read and overlayed on top of the
  * default configuration. Command line arguments will be applied
  * after this file is read.
  *
  * @see src/Phan/Config.php
  * See Config for all configurable options.
  *
  * A Note About Paths
  * ==================
  *
  * Files referenced from this file should be defined as
  *
  * ```
  *   Config::projectPath('relative_path/to/file')
  * ```
  *
  * where the relative path is relative to the root of the
  * project which is defined as either the working directory
  * of the phan executable or a path passed in via the CLI
  * '-d' flag.
  */
 return [
 
     'target_php_version' => '7.2',
 
     // If enabled, missing properties will be created when
     // they are first seen. If false, we'll report an
     // error message if there is an attempt to write
     // to a class property that wasn't explicitly
     // defined.
     'allow_missing_properties' => false,
 
     // If enabled, null can be cast as any type and any
     // type can be cast to null. Setting this to true
     // will cut down on false positives.
     'null_casts_as_any_type' => false,
 
     // If enabled, allow null to be cast as any array-like type.
     // This is an incremental step in migrating away from null_casts_as_any_type.
     // If null_casts_as_any_type is true, this has no effect.
     'null_casts_as_array' => true,
 
     // If enabled, allow any array-like type to be cast to null.
     // This is an incremental step in migrating away from null_casts_as_any_type.
     // If null_casts_as_any_type is true, this has no effect.
     'array_casts_as_null' => true,
 
     // If enabled, scalars (int, float, bool, string, null)
     // are treated as if they can cast to each other.
     // This does not affect checks of array keys. See scalar_array_key_cast.
     'scalar_implicit_cast' => false,
 
     // If enabled, any scalar array keys (int, string)
     // are treated as if they can cast to each other.
     // E.g. array<int,stdClass> can cast to array<string,stdClass> and vice versa.
     // Normally, a scalar type such as int could only cast to/from int and mixed.
     'scalar_array_key_cast' => true,
 
     // If this has entries, scalars (int, float, bool, string, null)
     // are allowed to perform the casts listed.
     // E.g. ['int' => ['float', 'string'], 'float' => ['int'], 'string' => ['int'], 'null' => ['string']]
     // allows casting null to a string, but not vice versa.
     // (subset of scalar_implicit_cast)
     'scalar_implicit_partial' => [],
 
     // If true, seemingly undeclared variables in the global
     // scope will be ignored. This is useful for projects
     // with complicated cross-file globals that you have no
     // hope of fixing.
     'ignore_undeclared_variables_in_global_scope' => true,
 
     // Set this to false to emit PhanUndeclaredFunction issues for internal functions that Phan has signatures for,
     // but aren't available in the codebase, or the internal functions used to run phan
     // (may lead to false positives if an extension isn't loaded)
     // If this is true(default), then Phan will not warn.
     'ignore_undeclared_functions_with_known_signatures' => true,
 
     // Backwards Compatibility Checking. This is slow
     // and expensive, but you should consider running
     // it before upgrading your version of PHP to a
     // new version that has backward compatibility
     // breaks.
     'backward_compatibility_checks' => false,
 
     // If true, check to make sure the return type declared
     // in the doc-block (if any) matches the return type
     // declared in the method signature.
     'check_docblock_signature_return_type_match' => false,
 
     // (*Requires check_docblock_signature_param_type_match to be true*)
     // If true, make narrowed types from phpdoc params override
     // the real types from the signature, when real types exist.
     // (E.g. allows specifying desired lists of subclasses,
     //  or to indicate a preference for non-nullable types over nullable types)
     // Affects analysis of the body of the method and the param types passed in by callers.
     'prefer_narrowed_phpdoc_param_type' => true,
 
     // (*Requires check_docblock_signature_return_type_match to be true*)
     // If true, make narrowed types from phpdoc returns override
     // the real types from the signature, when real types exist.
     // (E.g. allows specifying desired lists of subclasses,
     //  or to indicate a preference for non-nullable types over nullable types)
     // Affects analysis of return statements in the body of the method and the return types passed in by callers.
     'prefer_narrowed_phpdoc_return_type' => true,
 
     // If enabled, check all methods that override a
     // parent method to make sure its signature is
     // compatible with the parent's. This check
     // can add quite a bit of time to the analysis.
     // This will also check if final methods are overridden, etc.
     'analyze_signature_compatibility' => true,
 
     // This setting maps case insensitive strings to union types.
     // This is useful if a project uses phpdoc that differs from the phpdoc2 standard.
     // If the corresponding value is the empty string, Phan will ignore that union type (E.g. can ignore 'the' in `@return the value`)
     // If the corresponding value is not empty, Phan will act as though it saw the corresponding unionTypes(s) when the keys show up in a UnionType of @param, @return, @var, @property, etc.
     //
     // This matches the **entire string**, not parts of the string.
     // (E.g. `@return the|null` will still look for a class with the name `the`, but `@return the` will be ignored with the below setting)
     //
     // (These are not aliases, this setting is ignored outside of doc comments).
     // (Phan does not check if classes with these names exist)
     //
     // Example setting: ['unknown' => '', 'number' => 'int|float', 'char' => 'string', 'long' => 'int', 'the' => '']
     'phpdoc_type_mapping' => [],
 
     // Set to true in order to attempt to detect dead
     // (unreferenced) code. Keep in mind that the
     // results will only be a guess given that classes,
     // properties, constants and methods can be referenced
     // as variables (like `$class->$property` or
     // `$class->$method()`) in ways that we're unable
     // to make sense of.
     'dead_code_detection' => false,
 
     // If true, this run a quick version of checks that takes less
     // time at the cost of not running as thorough
     // an analysis. You should consider setting this
     // to true only when you wish you had more **undiagnosed** issues
     // to fix in your code base.
     //
     // In quick-mode the scanner doesn't rescan a function
     // or a method's code block every time a call is seen.
     // This means that the problem here won't be detected:
     //
     // ```php
     // <?php
     // function test($arg):int {
     //     return $arg;
     // }
     // test("abc");
     // ```
     //
     // This would normally generate:
     //
     // ```sh
     // test.php:3 TypeError return string but `test()` is declared to return int
     // ```
     //
     // The initial scan of the function's code block has no
     // type information for `$arg`. It isn't until we see
     // the call and rescan test()'s code block that we can
     // detect that it is actually returning the passed in
     // `string` instead of an `int` as declared.
     'quick_mode' => false,
 
     // If true, then before analysis, try to simplify AST into a form
     // which improves Phan's type inference in edge cases.
     //
     // This may conflict with 'dead_code_detection'.
     // When this is true, this slows down analysis slightly.
     //
     // E.g. rewrites `if ($a = value() && $a > 0) {...}`
     // into $a = value(); if ($a) { if ($a > 0) {...}}`
     'simplify_ast' => true,
 
     // Enable or disable support for generic templated
     // class types.
     'generic_types_enabled' => true,
 
     // Override to hardcode existence and types of (non-builtin) globals in the global scope.
     // Class names should be prefixed with '\\'.
     // (E.g. ['_FOO' => '\\FooClass', 'page' => '\\PageClass', 'userId' => 'int'])
     'globals_type_map' => [],
 
     // The minimum severity level to report on. This can be
     // set to Issue::SEVERITY_LOW, Issue::SEVERITY_NORMAL or
     // Issue::SEVERITY_CRITICAL. Setting it to only
     // critical issues is a good place to start on a big
     // sloppy mature code base.
     'minimum_severity' => Issue::SEVERITY_LOW,
 
     // Add any issue types (such as 'PhanUndeclaredMethod')
     // to this black-list to inhibit them from being reported.
     'suppress_issue_types' => [],
 
     // A regular expression to match files to be excluded
     // from parsing and analysis and will not be read at all.
     //
     // This is useful for excluding groups of test or example
     // directories/files, unanalyzable files, or files that
     // can't be removed for whatever reason.
     // (e.g. '@Test\.php$@', or '@vendor/.*/(tests|Tests)/@')
     'exclude_file_regex' => '@^vendor/.*/(tests?|Tests?)/@',
 
     // A file list that defines files that will be excluded
     // from parsing and analysis and will not be read at all.
     //
     // This is useful for excluding hopelessly unanalyzable
     // files that can't be removed for whatever reason.
     'exclude_file_list' => [],
 
     // A directory list that defines files that will be excluded
     // from static analysis, but whose class and method
     // information should be included.
     //
     // Generally, you'll want to include the directories for
     // third-party code (such as "vendor/") in this list.
     //
     // n.b.: If you'd like to parse but not analyze 3rd
     //       party code, directories containing that code
     //       should be added to the `directory_list` as
     //       to `excluce_analysis_directory_list`.
     'exclude_analysis_directory_list' => [
         'vendor/',
     ],
 
     // The number of processes to fork off during the analysis
     // phase.
     'processes' => 1,
 
     // List of case-insensitive file extensions supported by Phan.
     // (e.g. php, html, htm)
     'analyzed_file_extensions' => [
         'php',
     ],
 
     // You can put paths to stubs of internal extensions in this config option.
     // If the corresponding extension is **not** loaded, then phan will use the stubs instead.
     // Phan will continue using its detailed type annotations,
     // but load the constants, classes, functions, and classes (and their Reflection types)
     // from these stub files (doubling as valid php files).
     // Use a different extension from php to avoid accidentally loading these.
     // The 'tools/make_stubs' script can be used to generate your own stubs (compatible with php 7.0+ right now)
     'autoload_internal_extension_signatures' => [],
 
     // A list of plugin files to execute
     // Plugins which are bundled with Phan can be added here by providing their name (e.g. 'AlwaysReturnPlugin')
     // Alternately, you can pass in the full path to a PHP file with the plugin's implementation (e.g. 'vendor/phan/phan/.phan/plugins/AlwaysReturnPlugin.php')
     'plugins' => [
         'AlwaysReturnPlugin',
         'PregRegexCheckerPlugin',
         'UnreachableCodePlugin',
     ],
 
     // A list of directories that should be parsed for class and
     // method information. After excluding the directories
     // defined in exclude_analysis_directory_list, the remaining
     // files will be statically analyzed for errors.
     //
     // Thus, both first-party and third-party code being used by
     // your application should be included in this list.
     'directory_list' => [
         'src',
         'tests',
         'vendor/keruald/commands/src',
         'vendor/phan/phan/src/Phan',
         'vendor/phpunit/phpunit/src',
+        'vendor/vlucas/phpdotenv/src',
     ],
 
     // A list of individual files to include in analysis
     // with a path relative to the root directory of the
     // project
     'file_list' => [],
 ];
diff --git a/composer.json b/composer.json
index d600b1d..e87b441 100644
--- a/composer.json
+++ b/composer.json
@@ -1,27 +1,28 @@
 {
     "name": "nasqueron/saas-phpbb",
     "description": "Helper command to configure phpBB instances",
     "type": "project",
     "license": "BSD-2-Clause",
     "authors": [
         {
             "name": "Sébastien Santoro",
             "email": "dereckson@espace-win.org"
         }
     ],
     "require": {
-        "keruald/commands": "^0.0.1"
+        "keruald/commands": "^0.0.1",
+        "vlucas/phpdotenv": "dev-master"
     },
     "require-dev": {
         "nasqueron/codestyle": "0.0.1",
         "phan/phan": "^0.12.4",
         "phpunit/phpunit": "^7.0.3",
         "squizlabs/php_codesniffer": "^3"
     },
     "autoload": {
         "psr-4": {
             "Nasqueron\\SAAS\\PhpBB\\": "src/",
             "Nasqueron\\SAAS\\PhpBB\\Tests\\": "tests/"
         }
     }
 }
diff --git a/src/Runner/Application.php b/src/Runner/Application.php
index 23a0704..e142742 100644
--- a/src/Runner/Application.php
+++ b/src/Runner/Application.php
@@ -1,14 +1,23 @@
 <?php
 
 namespace Nasqueron\SAAS\PhpBB\Runner;
 
 use Keruald\Commands\Command;
 use Keruald\Commands\ExitCode;
 
+use Dotenv\Dotenv;
+
 class Application extends Command {
 
     public function main () : int {
+        self::loadEnvironment();
+
         return ExitCode::SUCCESS;
     }
 
+    private static function loadEnvironment () : void {
+        $dotenv = new Dotenv(__DIR__);
+        $dotenv->safeLoad();
+    }
+
 }
diff --git a/src/SitesRepository/Repository.php b/src/SitesRepository/Repository.php
new file mode 100644
index 0000000..842e13c
--- /dev/null
+++ b/src/SitesRepository/Repository.php
@@ -0,0 +1,7 @@
+<?php
+
+namespace Nasqueron\SAAS\PhpBB\SitesRepository;
+
+abstract class Repository {
+
+}
diff --git a/src/SitesRepository/SqliteRepository.php b/src/SitesRepository/SqliteRepository.php
new file mode 100644
index 0000000..30fd3a1
--- /dev/null
+++ b/src/SitesRepository/SqliteRepository.php
@@ -0,0 +1,80 @@
+<?php
+
+namespace Nasqueron\SAAS\PhpBB\SitesRepository;
+
+use PDO;
+
+class SqliteRepository extends Repository {
+
+    ///
+    /// Private members
+    ///
+
+    /**
+     * @var string
+     */
+    private $filename;
+
+    /**
+     * @var PDO
+     */
+    private $db = null;
+
+    ///
+    /// Constructor
+    ///
+
+    public function __construct (string $filename) {
+        $this->filename = $filename;
+    }
+
+    ///
+    /// Tasks methods
+    ///
+
+    public function bootstrap () : void {
+        $db = $this->getDB();
+
+        $queries = $this->getSchema();
+        foreach ($queries as $query) {
+            $db->query($query);
+        }
+    }
+
+    ///
+    /// Helper methods
+    ///
+
+    public function getDB() : PDO {
+        if ($this->db === null) {
+            if (!file_exists($this->filename)) {
+                touch($this->filename);
+            }
+
+            $dsn = self::getDataSourceName($this->filename);
+            $this->db = new PDO($dsn);
+        }
+
+        return $this->db;
+    }
+
+    private static function getDataSourceName (string $filename) : string {
+        return "sqlite:" . realpath($filename);
+    }
+
+    private function getSchema () : iterable {
+
+        yield <<<SQL
+CREATE TABLE IF NOT EXISTS sites (
+  id text,
+  host text,
+  db_user text,
+  db_password text,
+  db_prefix text,
+  active boolean
+);
+SQL;
+
+    }
+
+}
diff --git a/src/Tasks/BootstrapSqliteRepository.php b/src/Tasks/BootstrapSqliteRepository.php
new file mode 100644
index 0000000..f131b4d
--- /dev/null
+++ b/src/Tasks/BootstrapSqliteRepository.php
@@ -0,0 +1,26 @@
+<?php
+
+namespace Nasqueron\SAAS\PhpBB\Tasks;
+
+use Nasqueron\SAAS\PhpBB\SitesRepository\SqliteRepository;
+
+class BootstrapSqliteRepository extends Task {
+
+    /**
+     * @var string
+     */
+    private $filename;
+
+    public function __construct (?string $filename = null) {
+        $this->filename = $filename ?? $this->getDefaultFilename();
+    }
+
+    public function run () : void {
+        (new SqliteRepository($this->filename))->bootstrap();
+    }
+
+    private function getDefaultFilename() : string {
+        return $_ENV["SAAS_SITES_DB"];
+    }
+
+}
diff --git a/src/Tasks/Task.php b/src/Tasks/Task.php
new file mode 100644
index 0000000..088ccaf
--- /dev/null
+++ b/src/Tasks/Task.php
@@ -0,0 +1,9 @@
+<?php
+
+namespace Nasqueron\SAAS\PhpBB\Tasks;
+
+abstract class Task {
+
+    abstract public function run () : void;
+
+}
diff --git a/tests/SitesRepository/SqliteRepositoryTest.php b/tests/SitesRepository/SqliteRepositoryTest.php
new file mode 100644
index 0000000..d94097c
--- /dev/null
+++ b/tests/SitesRepository/SqliteRepositoryTest.php
@@ -0,0 +1,24 @@
+<?php
+declare(strict_types=1);
+
+namespace Nasqueron\SAAS\PhpBB\Tests\SitesRepository;
+
+use Nasqueron\SAAS\PhpBB\SitesRepository\SqliteRepository;
+use Nasqueron\SAAS\PhpBB\Tests\Utilities\WithSqliteAssertions;
+use PHPUnit\Framework\TestCase;
+
+final class SqliteRepositoryTest extends TestCase {
+
+    use WithSqliteAssertions;
+
+    public function testBootstrap () : void {
+        $filename = tempnam("", "test-db-");
+        $repository = new SqliteRepository($filename);
+        $repository->bootstrap();
+
+        $this->assertDatabaseHasBeenCreated($filename);
+
+        unlink($filename);
+    }
+
+}
diff --git a/tests/Tasks/BootstrapSqliteRepositoryTest.php b/tests/Tasks/BootstrapSqliteRepositoryTest.php
new file mode 100644
index 0000000..6e02aa1
--- /dev/null
+++ b/tests/Tasks/BootstrapSqliteRepositoryTest.php
@@ -0,0 +1,50 @@
+<?php
+declare(strict_types=1);
+
+namespace Nasqueron\SAAS\PhpBB\Tests\Tasks;
+
+use Nasqueron\SAAS\PhpBB\Tasks\BootstrapSqliteRepository;
+use Nasqueron\SAAS\PhpBB\Tests\Utilities\WithSqliteAssertions;
+use PHPUnit\Framework\TestCase;
+
+final class BootstrapSqliteRepositoryTest extends TestCase {
+
+    use WithSqliteAssertions;
+
+    /**
+     * @var string
+     */
+    private $filename;
+
+    ///
+    /// Fixtures
+    ///
+
+    public function setUp () {
+        $this->filename = tempnam("", "test-db-");
+    }
+
+    public function tearDown () {
+        unlink($this->filename);
+    }
+
+    ///
+    /// Tests
+    ///
+
+    public function testBootstrap () : void {
+        $task = new BootstrapSqliteRepository($this->filename);
+        $task->run();
+
+        $this->assertDatabaseHasBeenCreated($this->filename);
+    }
+
+    public function testBootstrapWithDefaultFile () : void {
+        $_ENV["SAAS_SITES_DB"] = $this->filename;
+        $task = new BootstrapSqliteRepository();
+        $task->run();
+
+        $this->assertDatabaseHasBeenCreated($this->filename);
+    }
+
+}
diff --git a/tests/Utilities/WithSqliteAssertions.php b/tests/Utilities/WithSqliteAssertions.php
new file mode 100644
index 0000000..a1562e7
--- /dev/null
+++ b/tests/Utilities/WithSqliteAssertions.php
@@ -0,0 +1,21 @@
+<?php
+declare(strict_types=1);
+
+namespace Nasqueron\SAAS\PhpBB\Tests\Utilities;
+
+use PHPUnit\Framework\Assert;
+
+trait WithSqliteAssertions {
+
+    public function assertDatabaseHasBeenCreated (string $filename) : void {
+        Assert::assertFileExists($filename);
+
+        // Checks the file isn't empty (ie some tables and perhaps data exist)
+        Assert::assertStringNotEqualsFile(
+            $filename,
+            '',
+            "Database file has been created but schema wasn't applied."
+        );
+    }
+
+}