DB Bot

DB Bot uses Natural Language Processing (NLP) to construct DB queries. What that means is you can interact with your database like you're talking to a human
Here's an example

> bot = DbBot.message('How many users signed up this week?')
> bot.response
=> "5 users"
> bot = DbBot.message('Find the last 10 users') 
> bot.response
=> "There you go"
> bot.collection
=> #<ActiveRecord::Relation [#<User id: 1...

It's rather basic at the moment but I'm working on incorporating more complex database queries.

Installation

Add this line to your application's Gemfile:

gem 'db_bot'

And then execute:

$ bundle

Or install it yourself as:

$ gem install db_bot

Getting Started

The only thing you'll need to do after installing db_bot is add our Wit.ai access token. This gives you access to all the language rules. You can view our project here https://wit.ai/dawilster/db_bot.

WIT_ACCESS_TOKEN=M4GJHCDJLSI34OTZW5M4NPP672IR3UOS

Then you can jump in and asks questions like.

> DbBot.message('How many users signed up last week?')
> DbBot.message('Display the 50 most recent sales')
> DbBot.message('How many sales does the item with id 103 have?') (coming soon)

Contributing

Bug reports and pull requests are welcome on GitHub at https://github.com/dawilster/db_bot. This project is intended to be a safe, welcoming space for collaboration, and contributors are expected to adhere to the Contributor Covenant code of conduct.

License

The gem is available as open source under the terms of the MIT License.