JackTable

JackTable ❄️

A beautiful, winter-themed local Airtable alternative with AI integration capabilities. Built for developers who want a customizable, local-first database interface that can be enhanced through Cursor IDE and Claude's AI capabilities.

Features

• 🎄 Festive winter theme with animated snowfall
• 👀 Multiple view layouts:
  • Grid View: Full table with sorting
  • List View: Card-based layout
  • Compact View: Condensed table
• 🔍 Global search across all columns
• ⚡️ Real-time sorting and filtering
• ✏️ Edit and delete records
• ➕ Add new records
• 🎯 Responsive design
• 🤖 AI Integration Ready:
  • Compatible with Cursor IDE's AI features
  • Can be extended to work with Claude's model context protocol
  • Update your database through natural language conversations

Why JackTable?

• Local-First: Your data stays on your machine, providing complete control and privacy
• Customizable: Built with developers in mind - easily modify the code to suit your needs
• AI-Ready: Designed to work seamlessly with modern AI tools and assistants
• Fast & Lightweight: No cloud dependencies, runs entirely on your local machine

Installation

1. Clone the repository:

git clone https://github.com/jackmielke/jacktable.git
cd jacktable

2. Install dependencies:

pip install -r requirements.txt

3. Run the application:

python app.py

4. Open your browser and visit: http://localhost:5000

AI Integration

JackTable is designed to work seamlessly with AI assistants. When used with Cursor IDE and Claude:

1. The database structure is automatically exposed to Claude's context
2. You can ask Claude to:
   • Query your data
   • Add new records
   • Update existing records
   • Create new tables
   • All through natural language!

Technologies Used

• Flask
• SQLite3
• Bootstrap 5
• Custom CSS animations
• AI Integration capabilities

Contributing

Feel free to fork, submit PRs, or customize for your own use! This project is meant to be a starting point for building your perfect local database interface.

License

MIT License - See LICENSE file for details