The iWork applications - Keynote, Pages & Numbers - can only open AppleWorks 6 presentation, word processing & spreadsheet documents, respectively. They will not open any other type of AppleWorks 6 files or any AppleWorks 5 or any version of ClarisWorks files.
The third-party application, EazyDraw (the expensive version), can open AppleWorks draw documents. If you still have access to AppleWorks you can copy the contents of draw documents, paste them into an AppleWorks word processing document in object mode (click the arrow in the tool panel), save the WP document & then open it in Pages. You can copy & paste from AppleWorks to Pages but you would have to do it object by object or it will be one big uneditable object.
There is nothing other than AppleWorks that can open paint or database documents. Database data can be copied & pasted into an AppleWorks spreadsheet, saved & opened in Numbers or saved as ASCII/plain text & opened in most any spreadsheet, database or word processing program. Paint documents can be saved as one of many different formats to be opened in most image editing programs. I recommend using PICT for best results.