SQLite MCP Server

{ "cells": [ { "cell_type": "code", "execution_count": 1, "id": "98246762", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "2" ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "1+1" ] }, { "cell_type": "code", "execution_count": 3, "id": "e59af552", "metadata": {}, "outputs": [], "source": [ "import sqlite3" ] }, { "cell_type": "code", "execution_count": 7, "id": "8a931a9a", "metadata": {}, "outputs": [], "source": [ "# SQLite database configuration\n", "#DB_PATH = \"/data/chinook.db\" \n", "\n", "DB_PATH = \"../data/chinook.db\"" ] }, { "cell_type": "code", "execution_count": 8, "id": "ca1efba7", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "['albums', 'sqlite_sequence', 'artists', 'customers', 'employees', 'genres', 'invoices', 'invoice_items', 'media_types', 'playlists', 'playlist_track', 'tracks', 'sqlite_stat1']\n" ] } ], "source": [ "with sqlite3.connect(DB_PATH) as conn:\n", " cursor = conn.cursor()\n", " cursor.execute(\"SELECT name FROM sqlite_master WHERE type='table';\")\n", " tables = [row[0] for row in cursor.fetchall()]\n", " print(tables)" ] } ], "metadata": { "kernelspec": { "display_name": ".venv", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.13.5" } }, "nbformat": 4, "nbformat_minor": 5 }