115 </div>
116 <div class="border rounded-lg p-4">
117 <h3 class="font-semibold text-green-600 mb-2">🗄️ SQLite Database</h3>
118 <ul class="text-sm text-gray-600 space-y-1">
119 <li>• sqlite_execute</li>
177 "List all available tools",
178 "Store some data in blob storage",
179 "Query the SQLite database",
180 "Send a test email",
181 "Read a project file",
6
7- **Blob Storage**: Read, write, list, and delete blob data
8- **SQLite Database**: Execute queries and manage database operations
9- **Email**: Send emails through Val Town's email service
10- **OpenAI Integration**: Access OpenAI API through Val Town's service
45 }
46
47 // Add database schema as a resource
48 resources.push({
49 uri: "sqlite://schema",
50 name: "SQLite Schema",
51 description: "Database schema information",
52 mimeType: "application/json"
53 });
146 };
147 } catch (error) {
148 throw new MCPException(MCP_ERRORS.INTERNAL_ERROR, `Error reading database schema: ${error.message}`);
149 }
150 }
34 - `blob_delete` - Delete blob
35
362. **SQLite Database**
37 - `sqlite_execute` - Execute SQL queries
38
54- `blob://[key]` - Blob storage items
55- `file://[path]` - Project files
56- `sqlite://schema` - Database schema
57- `env://info` - Environment variable info
30- [ ] add triggers to sidebar
31- [ ] add upload from SQL, CSV and JSON
32- [ ] add ability to connect to a non-val town Turso database
33- [x] fix wonky sidebar separator height problem (thanks to @stevekrouse)
34- [x] make result tables scrollable
4
5The directory is a simple
6database of Date Me Docs. Date Me Docs are long-form, earnest dating profiles for romantic partners.
7[Learn more here](https://dateme.directory/faq).
8
9## Todos
10
11- [ ] Make the SQLite database forkable and build a widget/workflow for that, ie fix @stevekrouse/dateme_sqlite
12- [ ] Require an email (that isn't shared publicly)
13 - [ ] Verify the email address with a "magic link"
345 }
346 } catch (e) {
347 console.error("Database error:", e);
348 await email({
349 subject: "Date Me Doc Submit Error: " + body["Name"],
383 );
384};
385// Database migration to add UserEmail column if it doesn't exist
386async function ensureUserEmailColumn() {
387 try {
4
5The directory is a simple
6database of Date Me Docs. Date Me Docs are long-form, earnest dating profiles for romantic partners.
7[Learn more here](https://dateme.directory/faq).
8
9## Todos
10
11- [ ] Make the SQLite database forkable and build a widget/workflow for that, ie fix @stevekrouse/dateme_sqlite
12- [ ] Require an email (that isn't shared publicly)
13 - [ ] Verify the email address with a "magic link"
1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { runMigrations } from "./database/migrations.ts";
3import itineraryRoutes from "./routes/itinerary.ts";
4import staticRoutes from "./routes/static.ts";
11});
12
13// Initialize database
14await runMigrations();
15